Welcome to MSDN Blogs Sign in | Join | Help

February 2007 - Posts

Monday, February 26, 2007 3:41 PM

PSS Service Center Labs for PASS 2006

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
Posted by psssql | 0 Comments
Filed under:
Wednesday, February 21, 2007 5:50 PM

SQL Server 2005 Performance Statistics Script

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
Posted by psssql | 7 Comments
Filed under:

Attachment(s): PerfStatsScript.zip
Wednesday, February 21, 2007 4:55 PM

SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!

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 next
Posted by psssql | 0 Comments
Attachment(s): test_linked_server.bmp
Wednesday, February 21, 2007 4:42 PM

Daylight Savings Time (DST) Changes for 2007 and their impact on SQL Server

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
Posted by psssql | 0 Comments
Filed under:
Wednesday, February 21, 2007 4:10 PM

SQL Server Urban Legends Discussed

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 File · A Disk Queue Length greater than 2 indicates an I/O bottleneck
Posted by psssql | 18 Comments
Filed under: , ,
Wednesday, February 21, 2007 1:47 AM

The Importance of the Trace Event Sequence Column and SQL Server 2005 SP2 Changes

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 Event
Posted by psssql | 0 Comments
Filed under: ,
Thursday, February 01, 2007 10:19 PM

SQL 2005 Setup Failures

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, in
Posted by psssql | 1 Comments
Filed under:
 
Page view tracker