Understanding Statistics In SQL Server

MP4 | Video: 1280x720 | 62 kbps | 48 KHz | Duration: 2 Hours | 252 MB

Genre: eLearning | Language: English

An exploration of what SQL Server statistics are, how SQL Server uses them, and how to use them to increase performance

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 are the requirements?

A copy of SQL Server 2008 R2 SP2 or later is recommended, although SQL 2005 can be used

Download the AdventureWords2012 sample database from CodePlex. The link is in the course and the free demo video.

Basic knowledge of Query Plans is helpful, but not required.

Basic knowledge of T-SQL is helpful, but not required.

What am I going to get from this course?

Over 17 lectures and 2 hours of content!

Almost 2 hours of content!

Improve SQL Server performance

Troubleshoot and fix SQL Server performance issues

Maintain statistics to ensure optimum SQL Server performance

What is the target audience?

This course is meant for advanced beginner to intermediate level DBAs who want to learn more about how statistics are created, used, and maintained in SQL Server.