This session focuses on the fundamentals of SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is the session for all those who have always found indexes confusing and somewhat elusive. We will use many analogies you are familiar with to describe index organization and give you the ability to identify when an index will help your query.