Optimizing Statisitics & Indexes

SQL Server 2016    |    Intermediate
  • 11 Videos | 1h 2m 47s
  • Includes Assessment
  • Earns a Badge
Likes 26 Likes 26
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
    FREE ACCESS
  • Locked
    4. 
    Updating Statistics
    3m 33s
    FREE ACCESS
  • Locked
    5. 
    Maintenance Tasks
    3m 25s
    FREE ACCESS
  • Locked
    6. 
    Database Engine Tuning Advisor
    7m 22s
    FREE ACCESS
  • Locked
    7. 
    Creating a Maintenance Plan
    6m 43s
    FREE ACCESS
  • Locked
    8. 
    Defragmenting Indexes
    9m 31s
    FREE ACCESS
  • Locked
    9. 
    Reviewing Dynamic Management Objects
    4m 34s
    FREE ACCESS
  • Locked
    10. 
    Overlapping Indexes
    4m 46s
    FREE ACCESS
  • Locked
    11. 
    Exercise: Work with Statistics and Optimize Indexes
    6m 13s
    FREE ACCESS

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

COURSE Performance Metrics
Likes 34 Likes 34  
BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
COURSE Index & Statistical Management
Likes 22 Likes 22  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Operators & Expressions
Likes 34 Likes 34  
COURSE Stored Procedures
Likes 61 Likes 61  
COURSE Database Programmability Objects & Non-relational Data
Likes 22 Likes 22