When we write our queries to the database, SQL Server has to go and figure out the best way to go and bring back the data you asked for. A query plan is created to help SQL Server remember how to get the data for this query. It takes time to make these queries, so the database wants to limit the number of times it has to create the plans so it will try to reuse the plan as much as possible.
Our topic for today's episode is query plan reuse and the pros and cons with this concept. We will also touch on the concept of parameter sniffing--a technique SQL Server uses to try and figure out the best values to use for the execution plan with the hopes the plan will help the most queries. Special thanks to James Youkhanis for the suggestion.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/07/04/episode-103-plan-reuse/ and have fun on the SQL trail.
Episode 156: Social Intelligence
Episode 155: Data Science
Episode 154: Test Driven Development
Episode 153: SQL Trail 2018 Retrospective
Episode 152: Do you use Analysis Services?
Episode 151: Azure SQL Database Managed Instance
Episode 150: The SQL Data Partners Team
Episode 149: Managing lots of databases
Episode 148: High Performance SSRS
Episode 147: Always Encrypted
Episode 146: SQL Trail Speakers
Episode 145: Is SSIS still relevant? Part 2
Episode 144: Is SSIS still relevant? Part 1
Episode 143: Transitioning from DBA to Data Warehouse Architect
Episode 142: Do You Have a HEAP of Hurting?
Episode 141: Wait, Wait, What?
Episode 140: Why data types matter
Episode 139: Getting Started with SQL Server in Azure
Episode 138: Meeting of the Minds
Episode 137: You want to work with Analytics?
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast