SQL Server - Filtered Indexes

Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index. In filtered index, you can define index to the filter portion of your data.