SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.
Register for this detail-packed seminar now!
This is the same content offered as a precon at large conferences, and it’s less than half the cost here!
For details about SQL Saturday Sacramento, including the exact location, you can go here.
SQL Server Query Plans: Reuse or Recompile
The seminar includes extensive demonstrations that illustrate the details of SQL Server plan caching and recompilation. We’ll look at the metadata available to help us explore the plan cache and discuss the various mechanisms that SQL Server uses to decide when and how to cache and reuse a plan.
This seminar will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2019, as well as SQL Server 2016, SQL Server 2014 and some earlier versions as well.
• Overview of Query Plans
• Optimization and Recompilation
• Exploring and Managing the Plan Cache
• Parameter Sniffing
• Determining when recompilation is preferable to plan reuse