Tim Chapman

SQL Server Dedicated Support Engineer (PFE)
  • Tim Chapman

    The Pains of Filtered Indexes

    In a previous post I briefly went over how useful filtered indexes can be. Filtered indexes are a great feature that have numerous uses. However, like almost everything in computing, there are trade-offs, and filtered indexes are no exception. The challenge...
  • Tim Chapman

    The Joys of Filtered Indexes

    A filtered index, introduced in SQL Server 2008, is a non-clustered index that contains only a subset of the number of rows contained in a table. Because there is a 1:1 ratio between the number of rows in a table and the number of rows in a regular non...
  • Tim Chapman

    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 use Dynamic Management Objects (views/functions) to expose a large portion of this information. However, some useful data isn't consumable by DMVs, so...
Page 1 of 1 (3 items)