Index & Statistical Management

SQL Server 2016    |    Intermediate
  • 14 Videos | 1h 32m 37s
  • Includes Assessment
  • Earns a Badge
Likes 22 Likes 22
By carefully managing aspects of your database, you can better tune performance and identify potential issues. Explore index management tasks, such as identifying and repairing fragmentation, and identifying and creating missing indexes.

WHAT YOU WILL LEARN

  • describe the types of indexes available in SQL Server and the importance of managing them properly
    detect fragmented indexes and determine the degree of fragmentation
    repair index fragmentation using SQL Server Management Studio
    repair index fragmentation using Transact-SQL
    use the Missing Indexes feature to identify missing indexes and to create them, if needed
    find and remove underutilized indexes
    describe the purpose of columnstore indexes, as well as why and when to use them
  • improve columnstore index performance
    defragment columnstore indexes
    identify and correct outdated statistics
    describe the purpose and characteristics of the auto_update_statistics option
    implement Auto Update Statistics
    implement statistics for large tables
    manage indexes in SQL Server 2016

IN THIS COURSE

  • Playable
    1. 
    Indexes
    6m 53s
    UP NEXT
  • Playable
    2. 
    Detecting Index Fragmentation
    6m 11s
  • Locked
    3. 
    Repairing Index Fragmentation Using SSMS
    3m 14s
  • Locked
    4. 
    Repairing Index Fragmentation Using T-SQL
    5m 2s
  • Locked
    5. 
    Identifying and Creating Missing Indexes
    8m
  • Locked
    6. 
    Finding and Removing Underutilized Indexes
    8m 23s
  • Locked
    7. 
    Columnstore Indexes
    10m 8s
  • Locked
    8. 
    Improving Columnstore Index Performance
    5m 22s
  • Locked
    9. 
    Defragmenting Columnstore Indexes
    4m 30s
  • Locked
    10. 
    Identifying Outdated Statistics
    6m 23s
  • Locked
    11. 
    Auto Update Statistics
    5m 10s
  • Locked
    12. 
    Implementing Auto Update Statistics
    6m
  • Locked
    13. 
    Implementing Statistics for Large Tables
    4m 30s
  • Locked
    14. 
    Exercise: Managing Indexes in SQL Server 2016
    6m 19s

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 1 Likes 1  
Likes 21 Likes 21  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 37 Likes 37  
COURSE T-SQL Queries
Likes 173 Likes 173  
COURSE Encryption
Likes 96 Likes 96