Uhm, I think you will need to provide a little more details to get an answer that is more than a complete guess. Could you please provide DDL for tables,...

From the interview:

since I am coming from Europe where executives never mix with the average worker, much less walking without an escort. I definitely got a sense that Microsoft is...

Thanks, I'll keep the URL for the tool for a later time.

It sounds very possible that the autogrowth is causing the problems. You can use both Profiler and/or Windows System Monitor (perfmon) to see when the files grow. However, like Remi...

Just to point it out: You do not need the /3GB switch. With an 8GB RAM dedicated SQL box you normally want to use it, but it is not a...

My general recommendation for scenarios such as this is that the DBMS should not be doing those kind of things. For this specific case I think you would even need...

The column will automatically be populated with incrementing numbers when it is added.

But why would you need to add a column that will not be used? If you are looking...

From a performance perspective, the answer is no (in normal cases at least). From a manageability perspective, yes and no.

I usually ask how...

As the discussion that Remi pointed to shows, yes, SQL Server 2005 CLR Integration does provide quite a log of new things regarding UDTs. My thoughts on CLR UDTs are...

From the KB article:

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.

Steve Jones has written a 4-part series regarding version control. Here is Part 4, with links to the three previous parts included.

Like sushila says, unicode means 2 bytes per character. Length is not the number of characters stored, but the number of bytes used for storage. E.g. and int shows 4...

No, there is no way to change the size of the MemToLeave area while running. As far as I know the -g startup parameter is the only way to configure...

hemant, please do not cross-post the same question. All boards are monitored and you will get an answer to your question even if you post it in the 'wrong' forum....

hemant, please do not cross-post the same question. All boards are monitored and you will get an answer to your question even if you post it in the 'wrong' forum....