Performance Tuning with Indexes: Internals and Best Practice

Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how  our indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries.  Knowing how indexes are useful can allow us to generalize some best practice
recommendations.  In this seminar we’ll look at the following topics:

.

Basic Index Structures
    Clustered vs nonclustered
    Unique vs non-unique
    Included columns

Tools for Exploring Index Structures

Index maintenance
    Page splits
    Fragmentation and Defragmentation

Index Design Considerations
    AND’s/ OR’s
    JOIN’s
    Composite Indexes

Best Practice Guidelines

Columnstore Index Storage

Columnstore Index  Guidelines