Despite of the fact the Query Optimizer represents one of the core engines of SQL Server there is only little know about the internals.
In this session, we will dive into the different trees and optimization phases of the query optimization. Also, we will understand the limits of the query engine. This knowledge will bring your query tuning to the next level.
Speaker for this event
MVP | MCSE | MCT
Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments.
He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.
Torsten is the founder of inside-sqlserver.com and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.
Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.