SQL Server Performance: Indexing Basics
This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.
What you'll learn
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of server.
Table of contents
- Introduction 2m
- Primary Key 1m
- Demo: Primary Key 4m
- Over Indexing 1m
- Demo: Over Indexing 2m
- Duplicate Index 1m
- Demo: Duplicate Index 3m
- Clustered Index 2m
- Demo: Clustered Index 3m
- Unique Index 1m
- Demo: Unique Index 4m
- Included Columns 1m
- Demo: Included Columns 4m
- Filtered Index 1m
- Demo: Filtered Index 4m
- Disabled Index 1m
- Demo: Disabled Index 4m
- Summary 1m
- Index and Page Types 2m
- Index and Non Deterministic Columns 2m
- Index and SET Values 1m
- Importance of Clustered Index 2m
- Effect of Compression and Fillfactor 3m
- Index and Functions 3m
- Dynamic Management Views (DMV) - Fillfactor 2m
- Table Scan, Index Scan and Index Seek 3m
- Index and Order of Columns 8m
About the authors
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences.