Burd's Q&A profile

• SQL Server Unable to truncate transaction log -- Replication was the problem

  I'm posting this because I just did quite a bit of searching on dealing with a huge transaction log that wouldn't truncate and didn't run across the solution for my issue, so I thought I'd post it here to help others. We had a Sql Server 2005 that had a huge transaction log and we were backing up the transaction log regularly. We couldn't get the log to shrink because sql server said it was in use. Turns out the problem was that we had played with having the database push a few tables to several sql server express edition databases via the builtin replication mechanisms. Those machines were no longer attempting to replicate however we hadn't turned replication off at the server. As a result it was leaving entries in the transaction ...Show All

• .NET Development Connecting to MS Sql Server 2005 with ODBC

  Hi there, I have just made a switch from sql server 2000 to sql server 2005 - that went without major problems... My server is located in Denmark. We have an office located in the US which are also connecting to our server - that goes without problems except for one machine connecting through ODBC directly (the others use remote desktop). The machine also connected through ODBC when I was using the old server - and there never seemed to be any problems. At first I could not see the machine by name, but I could ping it by ip-number. I added it to the hosts file - and now I can ping it by name as well. My problem is this: - When I try to correct the ODBC settings I do not get my new aerver on the sql-server list. D ...Show All

• Community Chat Kyro KidSafe Browser (beta)

  Hello all, I am making a "KidSafe" browser for kids. Please download my program and post any noticed bugs,etc.  It takes only minutes to set up.  I am 10 years old, so who can make a browser for kids better than a kid Progress:  Final will be started in January Thanks you everyone for your contributions  and encouragement.  *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. Beta Features: *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. *Talking Help guide *A new install program Updates in final version: *Button text replaced with graphics. *A game room with games, and fun KidSafe software (suc ...Show All

• Gadgets System.Network.Wireless Not Working

  It seems like System.Network.Wireless doesn't work... I have tried a few Windows Vista Sidebar gadets that use it and non of them work. I have also tried creating my own gadet and it doesn't work either. Has the object refrence been update but not the documentation Has anyone else seen this issue Or am I just doing something wrong I tried the following to have it printed out on the gadget and also saved in the Event Log and both places show that nothing is outputted. (and before it is asked, yes I do have wireless that is what I am using to write this and dont even have a hard connection) var IPAddress = System.Network.Wireless.address; gadgetContent.innerText = IPAddress; System.Diagnostics.EventLog.writeEntry(&quo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Indoor maps

  I'm making an FPS, but i'm wondering whats the best for the maps. Most stuff is made in 3D studio max and exported to .x files for now. Like for characters and weapos this is no problem, u can check if visible or not and stuff like that. But if u make 1 map in 3D studio and export to .x the entire map will be loaded and rendered ... whats best practice for this Well it depends on the graphics card and machine but the 1st thing to try is the naice approach of jsut rendering the whole thing. Depending on the materials and textures you can probably draw the whole level in less than 20 draw calls and GPUs are very very fast. If that doesn't work then you need to start partitioning up the mesh into sm ...Show All

• Windows Forms Capture Form Close

  Hi, I have a Form with 'OK' Button and 'Cancel' Button. If I click 'OK' the form closes and send some page to the Printer. 'Cancel' is to cancel printing.. Issue is, when i click Red Cross button to close the Window.. its giving print... which should perform same action as 'Cancel'.. How to capture when user clicks Cross button to close Window.. Thanks You can do something like this: enum CloseSource { FromOKButton, FromCancelButton, FromRedCross } Now Create a field to know how form was close like this: CloseSource howFormClosed; set its default value to: howFormClosed = CloseSource.FromRedCross; Now add this line to you OK Button: this.howFormClosed = FromOKButton; ...Show All

• SQL Server Aggregation Processing Use of All Processors Issue

  In 2000 when MSAS wanted to create aggs it did a great job without me doing anything of using all available processors pretty darn near or at 100%. In SSAS 2005 I have an 8-processor box (4 dual cores actually) and its only using 1 of the 8. Anyone know how to unlock that Some property perhaps Based on 8 processors I used 8 partitions and it did better, but not much. Then I tried 16 partitions (many programs use 4X threads per processor to maximize parellelization, but if something is well written 1x should be sufficient) and I think it helped - utilization is up to 30 or 40 percent during the cube process part, but the aggregation part is still pretty low - 20-30% overall. How many procs do you have ...Show All

• Visual Studio Team System Problems with run test coverage analisys on Build Machine

  Hello, I've following problem: I have test configuration with some unit-tests. Team Build was working correctly with this configuration. Then I've enable code coverage analysis. Now I cann't see test results files (Test Result directory is empty). Code coverage analisys cann't be started, and I cann't understand reason of it.   There is part of my build.log with errors:     Creating directory "C:\Build\Paladyne\Security Master Build\BuildType\..\Sources\..\TestResults".     __________________________________________________     Project "C:\Build\Paladyne\Security Master Build\BuildType\TFSBuild.proj" is building "C:\Build\Paladyne\Security Master Build\Bui ...Show All

• Windows Live Developer Forums Reading Multiple long. and lat points and plotting on VE

  Hi .. I'm new to VE and would like the best way and how to read and pass VE a list of Pin Points of long. and lat. thru asp.net. My database of points will be in either an MS/SQL or Access database. Thanks It depends on how many points you are talking about. I would look at using AJAX to pass the data to VE. If you have lots of pins you can then send data based on the current map view. Give me a yell if you need some examples. John. ...Show All

• SQL Server Grand Total Problem in Excel

  I found a problem when I use Excel 2003 with MSAS 2005. The problem occurs when I use the Hide Levels feature on a row dimension and select the grand total for columns option. I noticed that when I apply filters to the selection, the Grand Total does not reflect the filtered members. If I Show Details then the Grand Total is properly displayed. However, this problem does not happen on every diminsion. I was able to duplicate the problem using Adventure Works DW. In Excel, put the Product Categories in the Row, Source Currency Code in the Column, Sales Amount as the Data, and Filter on Weight (2.12) and Date.Calendar Year (CY 2004). Ensure that Grand Total for Columns is checked. Show Details down to the Product level; notice that the Grand ...Show All

• Visual C++ Templates overloades and specializations

  I want to create a function that returns the absolute value of a number. This number could be real (int, double, etc) or complex (of real, double, etc). I currently have the following: //--------------------------------------------------------------------- template<class data_t> data_t myAbs(data_t x) { return ((x > 0) (x):(-x)); } //--------------------------------------------------------------------- template<class data_t> data_t myAbs<complex<data_t> >(complex<data_t> x) { return (sqrt(x.real() * x.real() + x.imag() * x.imag())); } //--------------------------------------------------------------------- This compiles. However, when I call the function with a complex argument, the first function is c ...Show All

• Visual C++ C++ in visual

  I have just started using visual and my codes don't work. DO i have to change some setting or what's wrong. #include <iostream.h> main() { int a; int b = 20; int c = A + B; cout << "ENTER A VALUE FOR 'A' : "; cin >> a; cout << "Here is the ANSWER when u add 20 to ur varible: " << c ; return 0; } You have teo disable 'use precompiled headers" in your project options. Otherwise you have to create some magical stdafx.h and include it all over the place. The easiest solution if you're going to build from scratch is to disable precompiled headers however. Hope this helps. ...Show All

• .NET Development How to handle data in different tables?

  I was wondering if someone could point me to a tutorial that might help me I have an application that I'm developing that will display a tabbed form which needs to contain data from different tables. For example, my database has a contact table with typicall information and then it also has a lead table which contains information if the contact is a sales lead. They are linked together by a common contactID column. There are a few other normalized tables also like an AlternateAddress table. My first problem was that I could only get the binding source to connect to a particular table. This was a problem cause the data that I need to modify is normalized across a few different tables. My solution to that problem was to create a view ...Show All

• Visual Studio Team System Access to multiple excel sheets from on test method

  My test scenario requires me to access more than one excel sheets or more than one tables from one test method. Is it possible to access more than one excel sheets from datasource object Is it possible to use data source attribute to my private method (Which is not TestMethod()) Please reply. Thanks in advance. ~D Devpal, To the best of my knowledge, you can't inherently databind to multiple sheets at the same time. One way to get around this is to do the data query you're looking for inside of the Excel workbook itself, pulling all of your required data into a single table. From there, you can bind your test datasource to the new table. Here's an example connection string / que ...Show All

• SQL Server Is there anyway to do SUM on join table?

  I would like to start using SQL Server CE rather than SQLite for an application I am developing, due to it's replication support for SQL Server however there appears to be a gaping hole in it that means I can't even consider it. Specifically to do with aggregates against detail tables. Is there any way to do the equivalent of the following in SQL using SQL Server CE SELECT [Customer_Id], [Customer_name], COALESCE([OT].[Count_Orders],0) [CountOrders], COALESCE([OT].[Sum_Value],0) [OrderValue] FROM [Customers] LEFT OUTER JOIN (SELECT .[Customer_Id], COUNT(*) [Count_Orders], SUM( .[Order_Value]) [Sum_Value] FROM [Orders] GROUP BY .[Customer_Id]) [OT] ON [OT].[Customer_Id] = [Customers].[Customer_Id]); Any help would be most welcome Adrian ...Show All