Sql Server Radio
Episode 160 - OPTION RECOMPILE and the magical Turbo button
- Autor: Vários
- Narrador: Vários
- Editor: Podcast
- Duración: 0:32:49
- Mas informaciones
Informações:
Sinopsis
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