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.
AI Snips
Chapters
Transcript
Episode notes
Use Option Recompile Wisely
- Use option recompile to turbocharge slow reports without much effort.
- Apply it responsibly to avoid overusing and confusing Microsoft support.
Value of Query Store Hints
- Use Query Store hints especially when modifying application code is difficult.
- Be cautious about Query Store entering read-only mode.
Prefer Query Store Hints Over Plan Forcing
- Prefer Query Store hints over plan forcing for easier maintenance.
- Plan forcing is limited by available plans and feels like duct tape.