Here is a popular webinar from our recordings: SQL Server Indexes – Basics
SQL Server Indexes – Basics
Speaker: Satya Ramesh (Technical Consultant, SQLMaeatros)
Abstract: 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.
This is going to be a level 100 session targeted towards Developers & DBAs beginning their careers with SQL Server.