If I've learned anything from doing code reviews it is one thing: The majority of the time, there is a better way. The SQL Server optimizer can handle some things pretty well while near ignoring others, creating performance issues that can lead to nightmares. In this session we'll explore problematic coding situations and methods of resolving them. We'll also examine optimizer differences in older versus newer versions of SQL Server and solutions to performance issues encountered.
You will learn:
- How to use statistics to demonstrate the disparity in performance between two different queries that produce the same data
- Execution plans of good and poorly written queries, noting the differences and relating performance issues back to specific code segments
- The use of query store and demonstrate a performance gain with its use