Sign up to save your podcasts
Or
Share Episode 160 - OPTION RECOMPILE and the magical Turbo button
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
Episode 160 - OPTION RECOMPILE and the magical Turbo button
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
Relevant links for more info:
- OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn
- Recompile a Stored Procedure - SQL Server | Microsoft Learn
- Should I use option(recompile)? – SQLServerCentral
- SQL SERVER - Parameter Sniffing and OPTION (RECOMPILE) - SQL Authority with Pinal Dave
View all episodes
By Guy Glantser, Eitan Blumin
4.6
2020 ratings
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated.
Relevant links for more info:
- OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn
- Recompile a Stored Procedure - SQL Server | Microsoft Learn
- Should I use option(recompile)? – SQLServerCentral
- SQL SERVER - Parameter Sniffing and OPTION (RECOMPILE) - SQL Authority with Pinal Dave
More shows like SQL Server Radio
View all
This Week in Tech (Audio)
3,009 Listeners
Hanselminutes with Scott Hanselman
377 Listeners
.NET Rocks!
246 Listeners
WSJ What’s News
4,326 Listeners
WSJ Your Money Briefing
1,744 Listeners
The Rich Roll Podcast
11,749 Listeners
BiggerPockets Real Estate Podcast
16,811 Listeners
a16z Podcast
1,014 Listeners
SQL Data Partners Podcast
27 Listeners
Dear SQL DBA
28 Listeners
Revisionist History
59,388 Listeners
The Jordan B. Peterson Podcast
34,030 Listeners
Darknet Diaries
7,872 Listeners
The Indicator from Planet Money
9,520 Listeners
My First Million
2,618 Listeners