Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Understanding Statistics In SQL Server to your Wishlist.

Add to Wishlist

Understanding Statistics In SQL Server

An exploration of what SQL Server statistics are, how SQL Server uses them, and how to use them to increase performance
4.4 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
152 students enrolled
Created by Shaun Stuart
Last updated 7/2015
English
$15 $60 75% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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.

Who 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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Almost 2 hours of content!
Improve SQL Server performance
Troubleshoot and fix SQL Server performance issues
Maintain statistics to ensure optimum SQL Server performance
View Curriculum
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.
Curriculum For This Course
Expand All 17 Lectures Collapse All 17 Lectures 01:48:35
+
Introduction
2 Lectures 02:07

An overview of the topics this course will cover.

Preview 01:11
+
What Are Statistics And What Are They Used For?
5 Lectures 31:17

Learn what statistics are in SQL Server and what objects they are created on.

What Are Statistics?
01:24

How does SQL Server use statistics.

What Are Statistics Used For?
03:16

What permissions are needed to view statistics and how do you view them.

How Do You See Statistics?
02:29

What does a SQL Server statistic actually look like? Learn the three parts of statistic.

What Do Statistics Look Like?
10:34

A demo of how to view statistics using T-SQL code in SQL Server Management Studio.

Preview 13:34
+
When And How Are Statistics Created?
2 Lectures 16:36

Statistics can be created in a couple different ways.

Ways Statistics Are Created
08:53

A demo of automatically and manually created statistics.

Creating Statistics Demo
07:43
+
When And How Are Statistics Updated?
3 Lectures 22:17

The statistics auto-update process.

Automatic Updates
09:02

How to manually update statistics.

Manual Updates
03:23

A demo of both automatic and manual statistics updates.

Updating Statistics Demo
09:52
+
How Statistics Affect Performance
2 Lectures 19:23

How out of date statistics can cause performance issues.

Performance Implications
02:05

A demo of performance issues caused by out of date statistics.

Performance Issues Caused By Bad Statistics Demo
17:18
+
Problems And Solutions
2 Lectures 15:43

A description of a couple different problems that can be caused by bad statistics and how to overcome them.

Problems And Solutions
08:56

A demo of how uneven data distribution can cause performance issues, even with updated statistics.

Uneven Data Distribution Demo
06:47
+
Wrap Up
1 Lecture 01:12
Wrap Up
01:12
About the Instructor
4.0 Average rating
93 Reviews
1,112 Students
4 Courses
Senior SQL Server Database Administrator And Author

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.

Report Abuse