Understanding SQL Server Indexes – The Right Way by Satya Ramesh
In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes. 1. How to create them and some best practices to follow. 2. What is a covering index and how is it useful. 3. What is fragmentation and how to defrag indexes 4. What is fill factor and how is is useful.