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.
Lori Edwards is a Microsoft Certified SQL Server Database Administrator. She currently holds the position of Sales Engineer for SQLSentry. Prior to working with SQLSentry, she spent 10 years working as a production DBA. Between volunteering with the Program Committee coordinating with other volunteers to put the PASS Summit together, working as a remote employee over the last year and working with SQLSentry clients, she has had plenty of opportunity to hone her communication skills.