Next Meeting: Wed, Oct 05 2016
FoxPASS October 2016 Meeting
Event Type: In-Person & Online
Online Meeting URL: None
This month's meeting features Lori Edwards from SQL Sentry, helping us get better performance in SQL Server through statistics.
Event Time : Wed, Oct 05 2016 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Oct 05 2016 22:30 - 00:30
4351 W College Ave
SQL Server Statistics
Lori Edwards, Sales Engineer SQL Sentry
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/2016. 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.