SQL Server Radio

Episode 160 - OPTION RECOMPILE and the magical Turbo button


Listen Later

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
View all episodesView all episodes
Download on the App Store

SQL Server RadioBy Guy Glantser, Eitan Blumin

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

20 ratings


More shows like SQL Server Radio

View all
Fareed Zakaria GPS by CNN Podcasts

Fareed Zakaria GPS

3,402 Listeners

Voice of the DBA by Steve Jones

Voice of the DBA

9 Listeners

Top Traders Unplugged by Niels Kaastrup-Larsen

Top Traders Unplugged

594 Listeners

Software Engineering Radio by se-radio@computer.org

Software Engineering Radio

272 Listeners

The Cloudcast by Massive Studios

The Cloudcast

155 Listeners

SQL Data Partners Podcast by Carlos L Chacon

SQL Data Partners Podcast

27 Listeners

Science Vs by Spotify Studios

Science Vs

12,194 Listeners

Dear SQL DBA by Kendra Little

Dear SQL DBA

28 Listeners

Data Engineering Podcast by Tobias Macey

Data Engineering Podcast

145 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,519 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

245 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

All-In with Chamath, Jason, Sacks & Friedberg by All-In Podcast, LLC

All-In with Chamath, Jason, Sacks & Friedberg

9,833 Listeners

Hard Fork by The New York Times

Hard Fork

5,470 Listeners

Prof G Markets by Vox Media Podcast Network

Prof G Markets

1,327 Listeners