This course explains what statistics are in SQL Server, how the query engine uses them to generate query plans, and how you can tweak them to improve performance. It provides sample scripts and demonstrations.
The course will take just under 2 hours to complete. It consists of videos and demos. It also includes T-SQL scripts you can download for use on your own systems.
This course is intended for database administrators with an advanced-beginner to intermediate-level knowledge of SQL Server 2008, 2008 R2, or 2012.
Learn what statistics are in SQL Server and what objects they are created on.
How does SQL Server use statistics.
What permissions are needed to view statistics and how do you view them.
What does a SQL Server statistic actually look like? Learn the three parts of statistic.
Statistics can be created in a couple different ways.
A demo of automatically and manually created statistics.
The statistics auto-update process.
How to manually update statistics.
A demo of both automatic and manual statistics updates.
How out of date statistics can cause performance issues.
A demo of performance issues caused by out of date statistics.
A description of a couple different problems that can be caused by bad statistics and how to overcome them.
A demo of how uneven data distribution can cause performance issues, even with updated statistics.
Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.