Info

SQL Data Partners Podcast

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me and Steve on the SQL trail compañeros--you won't regret it.
RSS Feed Subscribe in Apple Podcasts
SQL Data Partners Podcast
2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: Page 1

Companeros, welcome to the SQL Data Partners Podcast, a podcast dedicated to SQL Server related topics which is designed to help you become familiar with what’s out there, how you might use features or ideas and how you might apply them in your environments.

Jul 5, 2017

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.

0 Comments