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 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 53sAfter 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 11sIn this video, you will learn how to detect fragmented indexes and determine the degree of fragmentation. FREE ACCESS
-
3. Repairing Index Fragmentation Using SSMS3m 14sDuring this video, you will learn how to repair index fragmentation using the SQL Server Management Studio. FREE ACCESS
-
4. Repairing Index Fragmentation Using T-SQL5m 2sIn this video, find out how to repair index fragmentation using Transact-SQL. FREE ACCESS
-
5. Identifying and Creating Missing Indexes8mIn this video, you will use the Missing Indexes feature to identify missing indexes and create them if needed. FREE ACCESS
-
6. Finding and Removing Underutilized Indexes8m 23sIn this video, you will learn how to find and remove indexes that are not being used. FREE ACCESS
-
7. Columnstore Indexes10m 8sUpon 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
-
8. Improving Columnstore Index Performance5m 22sIn this video, you will learn how to improve the performance of columnstore indexes. FREE ACCESS
-
9. Defragmenting Columnstore Indexes4m 30sFind out how to defragment columnstore indexes. FREE ACCESS
-
10. Identifying Outdated Statistics6m 23sLearn how to identify and correct statistics that are out of date. FREE ACCESS
-
11. Auto Update Statistics5m 10sAfter completing this video, you will be able to describe the purpose and characteristics of the auto update statistics option. FREE ACCESS
-
12. Implementing Auto Update Statistics6mIn this video, you will learn how to implement Auto Update Statistics. FREE ACCESS
-
13. Implementing Statistics for Large Tables4m 30sIn this video, find out how to implement statistics for large tables. FREE ACCESS
-
14. Exercise: Managing Indexes in SQL Server 20166m 19sIn 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.
