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.
What you'll learn
understand the role of statistics in SQL Server
analyze how the query engine utilizes statistics
learn techniques to improve performance through statistics