SQL Saturday Sacramento #222 Precon with Kalen Delaney
Sacramento SQL Server User Group will be hosting an all-day Precon on Friday July 26th
Performance Tuning with Indexes: Internals and Best Practices
Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how your 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
Early-Early Bird - $129 until April 30th, 2013 for the all day training which includes lunch.
Early Bird - $139 from May 1st until May 31st, 2013 for the all day training which includes lunch.
Staring June 1st, 2013, the cost will be full price at $149 which includes lunch.
Plan ahead and get in early!
About Kalen Delaney
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 O’Reilly/Microsoft Press. She is one of the main editors for SQL Server Central’s SQL Server Stairways series, http://www.sqlservercentral.com/stairway. Her most recent major editing project was as editor of SQL Server MVP Deep Dives, Volume 2, a collection of articles by SQL Server experts from around the world, with all the royalties going to charity.