Optimizing Statisitics & Indexes

SQL Server 2016
  • 11 Videos | 1h 7m 47s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. Discover how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016.

WHAT YOU WILL LEARN

  • create statistics and determine accuracy of results
    modify existing statistics
    view statistic properties
    update query optimization statistics
    describe available maintenance tasks to perform
    perform database tuning using the database engine tuning advisor
  • demonstrate how to create a maintenance plan
    perform index defragmentation
    review current index usage and identify missing indexes
    identify and consolidate overlapping indexes
    use statistics objects and index optimization methods

IN THIS COURSE

  • Playable
    1. 
    Creating Statistics
    7m 13s
    UP NEXT
  • Playable
    2. 
    Modifying Statistics
    3m 38s
  • Locked
    3. 
    Viewing Statistics Properties
    5m 48s
  • Locked
    4. 
    Updating Statistics
    3m 33s
  • Locked
    5. 
    Maintenance Tasks
    3m 25s
  • Locked
    6. 
    Database Engine Tuning Advisor
    7m 22s
  • Locked
    7. 
    Creating a Maintenance Plan
    6m 43s
  • Locked
    8. 
    Defragmenting Indexes
    9m 31s
  • Locked
    9. 
    Reviewing Dynamic Management Objects
    4m 34s
  • Locked
    10. 
    Overlapping Indexes
    4m 46s
  • Locked
    11. 
    Exercise: Work with Statistics and Optimize Indexes
    6m 13s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 24 Likes 24  
Likes 18 Likes 18  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 21 Likes 21  
COURSE T-SQL Queries
Likes 112 Likes 112  
Likes 61 Likes 61