Index & Statistical Management
SQL Server 2016
| Intermediate
- 14 Videos | 1h 26m 7s
- Includes Assessment
- Earns a Badge
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 properlydetect fragmented indexes and determine the degree of fragmentationrepair index fragmentation using SQL Server Management Studiorepair index fragmentation using Transact-SQLuse the Missing Indexes feature to identify missing indexes and to create them, if neededfind and remove underutilized indexesdescribe the purpose of columnstore indexes, as well as why and when to use them
-
improve columnstore index performancedefragment columnstore indexesidentify and correct outdated statisticsdescribe the purpose and characteristics of the auto_update_statistics optionimplement Auto Update Statisticsimplement statistics for large tablesmanage indexes in SQL Server 2016
IN THIS COURSE
-
1.Indexes6m 53sUP NEXT
-
2.Detecting Index Fragmentation6m 11s
-
3.Repairing Index Fragmentation Using SSMS3m 14s
-
4.Repairing Index Fragmentation Using T-SQL5m 2s
-
5.Identifying and Creating Missing Indexes8m
-
6.Finding and Removing Underutilized Indexes8m 23s
-
7.Columnstore Indexes10m 8s
-
8.Improving Columnstore Index Performance5m 22s
-
9.Defragmenting Columnstore Indexes4m 30s
-
10.Identifying Outdated Statistics6m 23s
-
11.Auto Update Statistics5m 10s
-
12.Implementing Auto Update Statistics6m
-
13.Implementing Statistics for Large Tables4m 30s
-
14.Exercise: Managing Indexes in SQL Server 20166m 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.