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