Get Accurate Estimates with Filtered Indexes

http://ift.tt/1uJYour

Improve cardinality estimates

Use filtered indexes and statistics for improved cardinality estimates.

read more

from SQL Server Pro http://ift.tt/1kCjeYg