17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
Training Day

A choice of full day instructor led training sessions, 2 May 2013


Performance Tuning with Indexes: Internals and Best Practice with Kalen Delaney


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