CSS SQL Server Engineers

Many folks asked us at PASS last year for these labs. A little late coming but we have these available if you want to download these. I've got these posted on Ken Henderson's website at http://sqlnexus.net/download/pass_2006_Web.zip . There is no official...

Many of you have used the SQL Server 2000 blocker script (see KB 271509 ) to help troubleshoot performance issues in SQL 2000. If you haven't used it, you probably use a script of your own that takes a similar approach, polling sysprocesses and virtual...

SQL Server 2005 Service Pack 2 (SP2) released on Monday to the web. If you want to start downloading it while reading the rest of the post, go right to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx . Over the...

As many of you know, Daylight Savings Time (DST) in the United States is changing this year to start on March 11th, 2007 (3 weeks earlier than normal) and end on November 4th, 2007 (1 week later than normal). I thought I would write a quick post on the...

I have been answering questions on two of the most misunderstood ‘SQL Server Urban Legends’ frequently again so I decided to make a post about them. ·          SQL Server Uses One Thread Per Data...

Many of us are used to looking at a SQL Trace and making the assumption that the order of display is what occurred during the capture. SQL Server 2005 introduced a new column named ‘Event Sequence’ that you should capture for any trace events. The...

This week I was reviewing Watson setup failure rates and comparing them to cases opened in the same areas with SQL Server support. Dec 2006 was the highest volume level for SQL Server 2005 RTM and SP1 cases to date. The values were not out of line...