Monthly Archives: November 2009

Day 1 At SQL PASS in Seattle

Posted on November 4, 2009 by Glenn Berry

Today was my big, somewhat stressful day at the PASS summit in Seattle. I gave two, 75-minute Community session  presentations, one on SQL Server 2008 Full Text Search at 10:15AM, and the other on DMV queries at 1:30PM. In between, … Continue reading →

Posted in SQL Server 2008 | 7 Comments

SQL Server 2008 Diagnostic Information Queries

Posted on November 3, 2009 by Glenn Berry

Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set of pretty heavily commented queries that are very useful for detecting and diagnosing many common performance issues with SQL Server … Continue reading →

Posted in Uncategorized | 21 Comments

Basic iFTS Monitoring Queries

Posted on November 2, 2009 by Glenn Berry

This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment” at 10:15-11:30AM in Room 608 at SQLPASS on … Continue reading →

Posted in SQL Server 2008 | 3 Comments

Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7

Posted on November 2, 2009 by Glenn Berry

Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL Server Setup blog that explains an occasional error that you can see when you install SQL Server 2008 or SQL … Continue reading →

Posted in SQL Server 2008 | 15 Comments

Two Very Important Configuration Settings For SQL Server 2005/2008

Posted on November 1, 2009 by Glenn Berry

Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server are “Lock pages in memory” and “Perform volume maintenance tasks”. These are actually User Rights Assignments in Windows that you … Continue reading →

Posted in SQL Server 2008 | 2 Comments