Company: Pluralsight Author: Gail Shaw Full Title: Optimizing SQL Server Statistics And Indexes Year: 2020 Language: English Genre: Educational: Databases Skill Level: Advanced Price: - - Files: MP4 (+ Exercise Files, Slides .PDF) Time: 01:49:27 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz 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. 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. Lessons: 1. Course Overview 01. Course Overview 2. Overview of Index Maintenance 02. Course Introduction 3. Review Index Usage and Identify Potential Missing Indexes 03. Why Do You Have Missing Indexes? 04. The Missing Index DMVs 05. Demo: Identifying Missing Indexes via the DMVs 06. Database Tuning Advisor 07. Demo: Database Tuning Advisor 08. Summary of Missing Indexes 09. Identfying Unused Indexes 10. Demo: Using the Index Usage DMV 11. Identifying Redundant Indexes 12. Demo: Redundant Indexes 13. Summary 4. Maintaining Rowstore Indexes 14. Introduction and Cause of Index Fragmentation 15. Effects of Fragmentation 16. Identifying Fragmented Indexes 17. Demo: Identifying Fragmented Indexes 18. Fixing Fragmentation 19. Demo: Fixing Fragmentation 20. Summary 5. Maintaining Columnstore Indexes 21. Introduction and Why Columnstore Indexes Need Maintenance 22. Demo: Identifying Columnstore Indexes in Need of Maintenance 23. Effects of Rebuild and Reorganize on Columnstore Indexes 24. Demo: Maintaining Columnstore Indexes 25. Summary 6. Maintaining Statistics 26. Introduction and What Are Statistics? 27. Demo: Reading Statistics and Their Effects on the Execution Plan 28. How Statistics Get Updated 29. Demo: Updating Statistics 30. Summary 7. Summary and Further Reading 31. Course Summary 32. Further Reading and Additional Courses Our members see more. Join us! ------------- Our members see more. Join us!