Filtered Indexes SQL Server 2008

RobertKaucher

I came accross a question in my test prep regarding filtered indexes and found a nice explanation. Figured I would share it:

SQL Server 2008 Introduces Filtered Indexes - Randy Dyess

astorrs

Very nice write-up thanks for sharing.

I can already see how I would've architected things differently on a large DB I designed a few years ago had these been available (ended up with some complex table partitioning).