SQL Server Statistics - What Are The Chances?

This session will explain how the Query Optimizer uses column statistics to determine which operators to use and the operator costs. We'll also look at the changes to the Cardinality Estimator in SQL Server 2014.

For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

Speaker

Lori Edwards is a Sales Engineer for SQLSentry. Prior to working with SQLSentry, she spent 11 years working as a production DBA.

Lori Edwards's Sessions

SQL Server Statistics - What Are The Chances?