Here are some suggestions on the abstract:

If you are a SQL Server Developer, DBA, Architect or you are someone working with SQL Server in any other capacity, it is very important to understand how indexes work. and how Creating proper indexes can boost your SQL Server performance considerably. Experts, often say 70% of performance problems can be treated by having proper indexing strategy. Even though the concept of indexing existed for years, still people have some misconceptions. This session is to take you back to the basics and help you understand the indexing structures from grass root level and to clear all the misconceptions you might have along the way. As most of the indexes found in OLTP are row-based, our concentration in this session will be completely on row-based indexing structures. We will be discussing the following topics along with supported demos.

1. How to create indexes 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 the fill factor and how is it useful.