-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: October 2018

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can be downloaded from Brent Ozar Unlimited.

Read more

0 comments, 91 reads

Posted in Gavin Draper's SQL Server Blog on 2 October 2018

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can be downloaded from Brent Ozar Unlimited.

Filtered Indexes are exactly that, indexes that have a predicate causing them to only contain a specific part of the overall data. For… Read more

0 comments, 101 reads

Posted in Gavin Draper's SQL Server Blog on 2 October 2018