Monthly Archives: December 2010

Updated SQL 2005 and 2008 Diagnostic Queries

Posted on December 29, 2010 by Glenn Berry

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

Posted on December 28, 2010 by Glenn Berry

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

Posted on December 27, 2010 by Glenn Berry

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

Posted on December 27, 2010 by Glenn Berry

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!

Posted on December 22, 2010 by Glenn Berry

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

Posted on December 22, 2010 by Glenn Berry

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

Posted on December 22, 2010 by Glenn Berry

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

SQL Server 2008 R2 RTM Cumulative Update 5 Released

Posted on December 20, 2010 by Glenn Berry

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753.  I count 40 separate fixes in this Cumulative Update, with quite a few SSAS fixes.

Posted in SQL Server 2008 R2 | Tagged | 1 Comment

SQL Server 2005 Service Pack 4 RTM Released

Posted on December 20, 2010 by Glenn Berry

Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server 2005. This is scheduled to be the last Service Pack for SQL Server 2005, which is not that surprising, since … Continue reading →

Posted in SQL Server 2005 | Tagged | 1 Comment

SQL Server Hardware Book

Posted on December 14, 2010 by Glenn Berry

One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working to finish my first solo book, SQL Server Hardware, which is due to be published in February 2011 by Simple … Continue reading →

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