Category Archives: non-clustered Indexes

Reducing size of a nonclustered index with Filtering

Posted on December 4, 2011 by

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