Monthly Archives: December 2011

Reducing size of a nonclustered index with Filtering

SQL Server 2008 has a very nice new feature that enables a partial index to be created based on a specific where clause. I have recently used┬áthis as an┬ásolution checking a table that contained an isSent flag. by creating a … Continue reading

Posted in database performance, filtered indexes, non-clustered Indexes, SQL, Uncategorized | Leave a comment