New Performance Features

SQL Server 2008 also introduces some new features and enhancements for monitoring, managing, and improving query performance. Among these new features are filtered indexes and statistics. A filtered index is a nonclustered index defined on a subset of data using a filter predicate to index only a portion of rows in the table. Filtered statistics are statistics defined on a subset of data in the table using a filter predicate. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes, especially when columns contain a large number of rows with null or a single value that isn’t searched on but can skew the index and statistics. ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.