Platinum Sponsor

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

Presented by Kalen Delaney at SQLBits XI
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Kalen in Office.jpg
    Kalen Delaney has been working with SQL Server for over 25 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2012 Internals, from Microsoft Press.  Kalen blogs at www.sqlblog.com.
    http://www.SQLServerInternals.com http://sqlblog.com/blogs/kalen_delaney/
  • Video
    The video is not available to view online.