Filtered Indexes, Sparse Columns: Together, Separately

Presenter: Don Vilen, Scalability Experts

Session 07 (18:00 GMT on May 19)

Session Details

SQL Server 2008 introduced Filtered Indexes and Sparse Columns. Although they are perhaps especially powerful when used together, they also can be used independently. This session covers the basics and then dives into the areas where they work well—and not so well—both together and separately.

About the Speaker

For the past two and a half years, Don Vilen has been Principal Architect at Scalability Experts, guiding SQL Server customers around the world through performance, upgrade, migration, and consolidation projects. Before November 2007, Don was on the Microsoft SQL Server team in Redmond, with 13 years of SQL Server experience at Microsoft. Don was a Program Manager for 6 years on the Storage Engine component of SQL Server, focusing on high availability and the storage of large objects. Before that, he spent 4 years creating and delivering training for Microsoft's SQL Server support engineers around the world. Prior to joining Microsoft, Don was on the computer science faculty at a California university and was also the Vice President of Software Development for a software company. Don is based principally in Seattle and New York City.