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, I hosted a Birds of a Feather table at lunch… Read more

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 2008.

-- SQL Server 2008 Diagnostic Information Queries
-- Glenn…

Read more

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 Tuesday, November 3. There are so many good… Read more

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 Server 2008 R2 August CTP on Windows 7 that looks… Read more

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 grant to the SQL Server Service account in Local Group… Read more