Monthly Archives: Feb 2013
The Truth about Cats and Dogs (Why Stored Procedures don’t use Filtered Indices)
With SQL Server 2008 came an interesting enhancement – the filtered index. This is a really useful tool when trying to deal with columns containing a wildly unbalanced distribution of values. For example in a database of medical patients, where … Continue reading
Posted in Indexing
Leave a comment
The results, if any, should be discarded... 