SQL Server Internals for Query Tuning provides the internal details you need to know to make sure you can get the best performance from your SQL Server queries.
This is an advanced course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.
Topics to be covered include the following:
- SQL Server Storage Metadata
- Tools for exploring storage structures
- Physical Storage Structures
- Query Processing and Query Plans
- Optimization and Recompilation
- Index Design and Tuning
- Statistics Internals and Management
- Query Tuning Tips and Techniques
Kalen Delaney is a SQL Server MVP and has been working with SQL Server for almost 31 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 2016 Internals: In-memory OLTP. Kalen’s website and blog can be found at www.SQLServerInternals.com