This resource is no longer available

SQL Server Statistics 101

Cover

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
Vendor:
Idera
Posted:
18 Jul 2014
Published:
18 Jul 2014
Format:
PDF
Length:
12 Page(s)
Type:
White Paper
Language:
English

This resource is no longer available.