Using Filtered Indexes to Improve Performance

(Dinesh Asanka) A Filtered Index is a new index type introduced in SQL Server 2008. In simple terms, rather than adding a non-clustered index to the entire table, you can add an index to a filtered data set.

Read More - Register for Free Membership