In this session you will learn the basics of how to tune queries in a SQL Server environment, through a demo-heavy and technique focused session. You will learn how to read an execution plan, and gain knowledge of techniques to improve query performance and throughput.
You will learn:
- How to read an execution plan
- Why SQL Server chooses the operators it does, and which ones are fastest
- About getting information from the Query Store