embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

SQL Server Statistics – What Are The Chances?

Speaker:

Lori Edwards

Abstract:

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.

Bio:

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.

Recorded At:

San Antonio SQL Saturday 2016

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>