Episode 160 - OPTION RECOMPILE and the magical Turbo button

Feb 12, 2024

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...

Read More