Monthly Archives: December 2010

Updated SQL 2005 and 2008 Diagnostic Queries

Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries. To go with them are the matching blank results … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged , | 9 Comments

The Importance of Windows Power Plans for Server Performance

This is a subject I have written about a couple of times before, here and in much more depth here.  Much more recently, fellow SQL Server MVP Brent Ozar (blog| twitter) has also blogged about this subject.  I thought I … Continue reading

Posted in Computer Hardware | Tagged , , | 7 Comments

SQL Server Workload Types and Hardware Selection

There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction Processing (OLTP) and the second being Decision Support (DSS)/Data Warehouse (DW). OLTP workloads are characterized by numerous, short transactions, where … Continue reading

Posted in Computer Hardware | Tagged , | 4 Comments

A Collection of Good Information About Controlling VLFs in SQL Server

Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged , | 1 Comment

Intel Sandy Bridge Processor Machines Coming Soon!

If you are in the market to buy or build a new laptop or desktop computer, you might want to wait a few weeks, for several reasons. First, Intel is going to formally roll out the brand new Sandy Bridge … Continue reading

Posted in Processors | Tagged , | Leave a comment

SQL Server 2005 SP3 Cumulative Update 13 Released

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday, but the “View and request hotfix downloads” link was broken until earlier today.  I waited to blog about it until … Continue reading

Posted in SQL Server 2005 | Tagged | 3 Comments

SQL Server Scripts Manager From Redgate Software

Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as one of the nine authors of the included scripts. It is always nice to get a free tool that does … Continue reading

Posted in SQL Server 2008 R2 | Tagged , , | 2 Comments