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
Tools for Exploring Index Structures
Fragmentation and Defragmentation
Index Design Considerations
Best Practice Guidelines
Columnstore Index Storage
Columnstore Index Guidelines
Sorry, there are no downloads available for this session.
Kalen Delaney has been working with SQL Server for over 26 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 2014 Internals: In-memory OLTP, from Red Gate. Kalen blogs at www.sqlblog.com
The video is not available to view online.