4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Training Days

A choice of full day expert led training sessions.


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