Optimizing SQL Server Statistics and Indexes

Focused View

Gail Shaw

1:49:27

94 View

1. Course Overview

1. Course Overview.mp4

01:04

2. Overview of Index Maintenance

1. Course Introduction.mp4

03:11

3. Review Index Usage and Identify Potential Missing Indexes

01. Why Do You Have Missing Indexes.mp4

04:04

02. The Missing Index DMVs.mp4

04:11

03. Demo. Identifying Missing Indexes via the DMVs.mp4

04:04

04. Database Tuning Advisor.mp4

06:11

05. Demo. Database Tuning Advisor.mp4

10:38

06. Summary of Missing Indexes.mp4

00:33

07. Identfying Unused Indexes.mp4

03:36

08. Demo. Using the Index Usage DMV.mp4

03:35

09. Identifying Redundant Indexes.mp4

01:38

10. Demo. Redundant Indexes.mp4

04:03

11. Summary.mp4

00:50

4. Maintaining Rowstore Indexes

1. Introduction and Cause of Index Fragmentation.mp4

03:12

2. Effects of Fragmentation.mp4

02:37

3. Identifying Fragmented Indexes.mp4

01:00

4. Demo. Identifying Fragmented Indexes.mp4

02:56

5. Fixing Fragmentation.mp4

07:51

6. Demo. Fixing Fragmentation.mp4

03:35

7. Summary.mp4

00:24

5. Maintaining Columnstore Indexes

1. Introduction and Why Columnstore Indexes Need Maintenance.mp4

03:45

2. Demo. Identifying Columnstore Indexes in Need of Maintenance.mp4

02:30

3. Effects of Rebuild and Reorganize on Columnstore Indexes.mp4

02:24

4. Demo. Maintaining Columnstore Indexes.mp4

02:39

5. Summary.mp4

00:26

6. Maintaining Statistics

1. Introduction and What Are Statistics.mp4

03:55

2. Demo. Reading Statistics and Their Effects on the Execution Plan.mp4

05:40

3. How Statistics Get Updated.mp4

04:04

4. Demo. Updating Statistics.mp4

02:35

5. Summary.mp4

02:40

7. Summary and Further Reading

1. Course Summary.mp4

07:15

2. Further Reading and Additional Courses.mp4

02:21

Description

How should indexes be maintained? Do columnstore indexes need maintenance? What should I do about statistics? All those questions and more are answered in this course. See how to maintain your indexes to keep your database running smoothly.

What You'll Learn?

Index maintenance is a complex topic, and one that's crucial for a well-performing database. In this course, Optimizing SQL Server Statistics and Indexes, you will learn foundational knowledge on how to keep your database and indexes well-maintained. First, you will explore missing and unused indexes, looking at how the indexes used by the system change over time. Next, you will discover why indexes, rowstore, and columnstore need maintenance and how to best perform that maintenance. Finally, you will learn how to perform statistics maintenance, allowing you to ensure that the Query Optimizer gets the information it needs to generate good execution plans. When you are finished with this course, you will have the skills and knowledge of index maintenance needed to keep your database running smoothly.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Statistics

SQL Server

Microsoft SQL

Gail Shaw

Instructor's Courses

Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related. She lives in Johannesburg, South Africa.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.