Episode 160 - OPTION RECOMPILE and the magical Turbo button
SQL Server Radio

Episode 160 - OPTION RECOMPILE and the magical Turbo button

2024-02-12

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
Comments (3)

More Episodes

All Episodes>>

Get this podcast on your phone, Free

Create Your Podcast In Minutes

  • Full-featured podcast site
  • Unlimited storage and bandwidth
  • Comprehensive podcast stats
  • Distribute to Apple Podcasts, Spotify, and more
  • Make money with your podcast
Get Started
It is Free