
Dear SQL DBA
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
May 20, 2024
Join SQL Server experts Erik Darling and Kendra Little as they explore a treasure trove of performance tuning techniques. They rate everything from recompile hints to scalar UDFs, adding humor to the complexities of optimization. Discover their takes on new features like the Query Store and the Resource Governor. They debate the merits of Common Table Expressions and index rebuilding while reflecting on memory management. With insights on filtered indexes and the future of T-SQL, this conversation is a must-listen for anyone passionate about SQL Server performance.
01:04:36
Episode guests
AI Summary
AI Chapters
Episode notes
Podcast summary created with Snipd AI
Quick takeaways
- Recompile hints are regarded positively for their simplicity and effectiveness in resolving complex query performance issues rapidly.
- Kendra and Eric express cautious optimism towards Query Store hints, noting their potential to optimize poorly performing queries without application code changes.
Deep dives
Introduction of Hosts
The episode begins with host Kendra Little and guest Eric Darling introducing themselves. Kendra humorously describes her background and the content she shares on her website focused on SQL Server topics. Eric shares his identity as a performance tuning consultant while joking about the commonality of his name. They engage in light banter about other individuals with the same name, setting a relaxed tone for the discussion.
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.