AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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.
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode