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:
We had a technical issue with this month’s recording, so instead we’re going back to one of our favorite shows – Big Mistakes with Brent Ozar.
Enjoy, and we’ll be back with new stuff in a few weeks.
Among other mistakes, we talk about:
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:
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager.
Relevant links:
Also, Happy New Year! 🎉🎈🥂
Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads.
Relevant links:
SQL Server Radio is going on a short break this month.
Please tune in next month for when we'll be coming back!
In the meantime, check out some of our favorite past episodes:
Guy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption.
Relevant links:
Guy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server.
Relevant links:
PWDENCRYPT and PWDCOMPARE
And also, don’t forget to register for the upcoming Data TLV Summit!
Today we have Kevin Chant as our guest!
We talk about Kevin’s favorite topics: Microsoft Fabric, Azure DevOps, SQL Server, and more.
Relevant links:
Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about!
Relevant links:
As promised in the previous episode, Guy and Eitan interview an actual human this time!
The one and only, the famed Erik Darling is our guest for today!
Check out his official website:
We apologize in advance for Guy's occasional audio glitches, as he was having network issues on the day of recording.
Guy and Eitan try something new for today's show - we interview ChatGPT as our guest for today, and make it pretend that it's a SQL Server expert!
Let's see how it does.
Relevant links:
Stay up to date
For any inquiries, please email us at hello@podcastworld.io