Tim Chapman

SQL Server Dedicated Support Engineer (PFE)

Browse by Tags

Tagged Content List
  • Blog Post: 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-clustered index, a filtered index can have performance...
  • Blog Post: 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 with filtered indexes is the decisions that...
Page 1 of 1 (2 items)