Index & Statistical Management

SQL Server 2016    |    Intermediate
  • 14 videos | 1h 26m 7s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 18 users Rating 4.4 of 18 users (18)
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

  • 6m 53s
    After completing this video, you will be able to describe the types of indexes available in SQL Server and why it is important to manage them properly. FREE ACCESS
  • 6m 11s
    In this video, you will learn how to detect fragmented indexes and determine the degree of fragmentation. FREE ACCESS
  • Locked
    3.  Repairing Index Fragmentation Using SSMS
    3m 14s
    During this video, you will learn how to repair index fragmentation using the SQL Server Management Studio. FREE ACCESS
  • Locked
    4.  Repairing Index Fragmentation Using T-SQL
    5m 2s
    In this video, find out how to repair index fragmentation using Transact-SQL. FREE ACCESS
  • Locked
    5.  Identifying and Creating Missing Indexes
    8m
    In this video, you will use the Missing Indexes feature to identify missing indexes and create them if needed. FREE ACCESS
  • Locked
    6.  Finding and Removing Underutilized Indexes
    8m 23s
    In this video, you will learn how to find and remove indexes that are not being used. FREE ACCESS
  • Locked
    7.  Columnstore Indexes
    10m 8s
    Upon completion of this video, you will be able to describe the purpose of columnstore indexes, as well as why and when to use them. FREE ACCESS
  • Locked
    8.  Improving Columnstore Index Performance
    5m 22s
    In this video, you will learn how to improve the performance of columnstore indexes. FREE ACCESS
  • Locked
    9.  Defragmenting Columnstore Indexes
    4m 30s
    Find out how to defragment columnstore indexes. FREE ACCESS
  • Locked
    10.  Identifying Outdated Statistics
    6m 23s
    Learn how to identify and correct statistics that are out of date. FREE ACCESS
  • Locked
    11.  Auto Update Statistics
    5m 10s
    After completing this video, you will be able to describe the purpose and characteristics of the auto update statistics option. FREE ACCESS
  • Locked
    12.  Implementing Auto Update Statistics
    6m
    In this video, you will learn how to implement Auto Update Statistics. FREE ACCESS
  • Locked
    13.  Implementing Statistics for Large Tables
    4m 30s
    In this video, find out how to implement statistics for large tables. FREE ACCESS
  • Locked
    14.  Exercise: Managing Indexes in SQL Server 2016
    6m 19s
    In this video, find out how to manage indexes in SQL Server 2016. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Instance Performance
Rating 4.7 of 47 users Rating 4.7 of 47 users (47)
Course SQL Platform & Installation Best Practices
Rating 4.5 of 50 users Rating 4.5 of 50 users (50)
Course Managing Database Integrity
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)