PLU | Optimizing SQL Server Statistics And Indexes (2020 EN)

Discussion in 'Information Technology' started by Kanka, Apr 12, 2020.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,086
    Likes Received:
    446
    Trophy Points:
    83
    [​IMG]

    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


    -------------