Optimizing Statisitics & Indexes

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 2m 47s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
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

  • 7m 13s
    In this video, you will learn how to create statistics and determine the accuracy of your results. FREE ACCESS
  • 3m 38s
    Learn how to modify existing statistics. FREE ACCESS
  • Locked
    3.  Viewing Statistics Properties
    5m 48s
    In this video, find out how to view statistics properties. FREE ACCESS
  • Locked
    4.  Updating Statistics
    3m 33s
    In this video, you will learn how to update statistics used for query optimization. FREE ACCESS
  • Locked
    5.  Maintenance Tasks
    3m 25s
    After completing this video, you will be able to describe available maintenance tasks to perform. FREE ACCESS
  • Locked
    6.  Database Engine Tuning Advisor
    7m 22s
    In this video, you will tune databases using the database engine tuning advisor. FREE ACCESS
  • Locked
    7.  Creating a Maintenance Plan
    6m 43s
    In this video, you will learn how to create a maintenance plan. FREE ACCESS
  • Locked
    8.  Defragmenting Indexes
    9m 31s
    Learn how to defragment indexes. FREE ACCESS
  • Locked
    9.  Reviewing Dynamic Management Objects
    4m 34s
    In this video, you will learn how to review current index usage and identify indexes that are missing. FREE ACCESS
  • Locked
    10.  Overlapping Indexes
    4m 46s
    Learn how to identify and combine overlapping indexes. FREE ACCESS
  • Locked
    11.  Exercise: Work with Statistics and Optimize Indexes
    6m 13s
    In this video, learn how to use statistical objects and index optimization methods. 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

Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Analyzing Query Plans
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
Course Index & Statistical Management
Rating 4.4 of 18 users Rating 4.4 of 18 users (18)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure SQL Database
Rating 4.3 of 88 users Rating 4.3 of 88 users (88)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course Six Sigma Black Belt: Using Lean Control Tools and Maintaining Controls
Rating 4.4 of 77 users Rating 4.4 of 77 users (77)