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.7 (12 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.
123 students enrolled
Instructed by Shaun Stuart Development / Databases
$19
$60
68% off
Take This Course
  • Lectures 17
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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.

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?

  • 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Instructor Details
Preview
00:56
01:11

An overview of the topics this course will cover.

Section 2: What Are Statistics And What Are They Used For?
01:24

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

03:16

How does SQL Server use statistics.

02:29

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

10:34

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

13:34

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

Section 3: When And How Are Statistics Created?
08:53

Statistics can be created in a couple different ways.

07:43

A demo of automatically and manually created statistics.

Section 4: When And How Are Statistics Updated?
09:02

The statistics auto-update process.

03:23

How to manually update statistics.

09:52

A demo of both automatic and manual statistics updates.

Section 5: How Statistics Affect Performance
02:05

How out of date statistics can cause performance issues.

17:18

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

Section 6: Problems And Solutions
08:56

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

06:47

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

Section 7: Wrap Up
Wrap Up
01:12

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shaun Stuart, 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.

Ready to start learning?
Take This Course