Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server Dedicated Support Engineer (PFE)
Visualizing Index Fragmenation
We all probably realize that fragmentation can be a performance hindrance, especially for scanning...
Date: 12/03/2012
Index Rebuild vs Reorganize: The transaction log edition
Recently a friend and fellow PFE Dave Levy (Twitter/Blog) and I were discussing a question someone...
Date: 09/28/2012
Optimizing ad-hoc workloads
Today's tip isn't necessarily low-level, but it is a setting that you should consider turning on for...
Date: 09/10/2012
The Joys of Filtered Indexes
A filtered index, introduced in SQL Server 2008, is a non-clustered index that contains only a...
Date: 08/27/2012
The Pains of Filtered Indexes
In a previous post I briefly went over how useful filtered indexes can be. Filtered indexes are a...
Date: 08/27/2012
How to Parse DBCC MEMORYSTATUS via Powershell
SQL Server has many ways to dig deep into diagnosing memory related problems. Today it is common to...
Date: 08/16/2012