Before answering your question, let me ask another question. What are you going to do if you need to add a third SQL Server into the mix? In short, your...

A plasma tv will be obsolete in 2 to 3 years and broken in 4 to 6. Diamonds are forever. The $17K spent on wedding rings is cheaper than it...

The problem with using xp_cmdshell is that it executes everything locally on the SQL Server. I don't know about you, but I don't allow people to install programs or put...

Production has 15 servers with 3 SQL 2000 and 12 SQL 2005. We will migrate the remaining databases off of 2000 onto 2005 in the next month or two and...

You don't need to create a view with the wildcards built in. You can do it like I did above. Using a view like this would be comparable to pushing...

If you do a join using LIKE without using any wildcards, it is the same as doing the join using an = instead of LIKE ..... only slower. So, all...

I've had a lot of luck with setting global variables at runtime using an ActiveX script task. Here's a sample of one where I set the variable based on a...

My mother called me one day worried that she had done something really bad. She said that she had deleted everything on the desktop of the computer (which is where...

I totally agree with Colin!!!

I recently accepted a dba position at a new company, so I just went through a 2 hour technical interview and am helping interview my replacement...

High profile prosecutions and penalties will never exist until the government stops being one of the worst offenders!!!

Who is going to go after the CIA for a laptop getting stolen?...

The SP's are cumulative. Everything in SP3 is in SP4 as well. You can install it over SP1 if you want. Just be aware that there are some post-SP3 (SP3a...

You should do that with every SP even if there have been no reported problems.

Thanks!!!

Any suggestions on where to look first for the best practices for running SQL Server on a SAN?

Our old SA has left and our new SA has declared that everything...

There is a laundry list of post-SP4 hotfixes available. Read through them to see what the identified and corrected issues are: http://support.microsoft.com/kb/894905/