This resource is no longer available
SQL Server Statistics 101
Statistics are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are at the core of query optimization and can have tremendous effect on query plan selection.
Poor statistics, whether they are skewed or incorrect, can cause massive performance problems when they lead to selection of a bad plan.
This white paper discusses how SQL Server uses data findings, and how you can view them to gain a better understanding of the information they contain. Topics include:
- Viewing statistics data
- Maintaining Statistics
- Parameter sniffing
- And more