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.
Chapters
Transcript
Episode notes
1 2 3 4 5 6 7 8 9 10
Intro
00:00 • 2min
Chatting About 'Eric' and SQL Tuning
01:57 • 4min
Optimizing SQL Queries: Techniques and Tools
05:39 • 7min
SQL Server Performance Tuning Insights
12:33 • 15min
Performance Tuning in SQL Server
27:59 • 14min
Mastering SQL Server Performance Tuning
41:35 • 16min
Easing Fears: Database Recovery and Query History
57:07 • 2min
Exploring Scalar UDFs: Promises and Pitfalls in SQL Server
58:55 • 2min
Evaluating SQL Server Performance Tuning Techniques
01:00:26 • 2min
Reflecting on SQL Performance Tuning and Future Events
01:02:02 • 3min