Category Archives: SQL Server 2008

April Version of SQL Server 2008 Diagnostic Queries

Posted on April 11, 2011 by Glenn Berry

I have added two new queries to this month’s version, to try to collect some more hardware information about the database server. I specifically wanted to find out more information about the processor type from T-SQL, since many DBAs don’t … Continue reading →

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

Presenting Dr. DMV by Live Meeting on April 19 at 12PM CDT

Posted on April 7, 2011 by Glenn Berry

I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19. Here are the meeting details: Join the STLSSUG for a Live Meeting Lecture Tuesday on April 19th from 12-1:00pm CDT Dr. … Continue reading →

Posted in PASS, SQL Server 2008, SQL Server 2008 R2, Teaching | Tagged , | Leave a comment

SQL Server 2008 SP2 Cumulative Update 3

Posted on March 22, 2011 by Glenn Berry

Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in the Knowledge Base article for the Cumulative Update. Here is the SQL Server 2008 CU Build Matrix: — SQL Server … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

SQL Server 2008 SP1 Cumulative Update 13

Posted on March 22, 2011 by Glenn Berry

Microsoft has released  SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in the Knowledge Base article for the Cumulative Update. I am a little surprised that they did not skip the unlucky … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

Mirrored Database Backups vs. Striped Database Backups

Posted on March 13, 2011 by Glenn Berry

I have seen a few people get confused about the difference between a mirrored database backup (which is only available in SQL Server 2005 Enterprise Edition and above) and a striped database backup. A Mirrored Backup is simply a database … Continue reading →

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

March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries

Posted on March 7, 2011 by Glenn Berry

Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL Server 2008/2008 R2. I have uploaded the scripts for each version to DropBox (see the links below). There are two … Continue reading →

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

Some Suggested SQL Server 2008 R2 Instance Configuration Settings

Posted on February 24, 2011 by Glenn Berry

Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level settings that you should consider changing from their default values. These include Max Server Memory, optimize for ad-hoc workloads,  default … Continue reading →

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

How to Interpret SELECT @@VERSION in SQL Server

Posted on February 17, 2011 by Glenn Berry

One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly understand the results that are returned. I have seen many people mix up the SQL Server portion of the results … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged | 3 Comments

SQL Server and the “Lock pages in memory” Right in Windows Server

Posted on February 14, 2011 by Glenn Berry

Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL Server community and within Microsoft about whether and when you should enable this setting. Before you decide whether you want … Continue reading →

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

Windows Instant File Initialization and SQL Server

Posted on February 10, 2011 by Glenn Berry

One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or … Continue reading →

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