Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Dear SQL DBA
Optimizing SQL Queries: Techniques and Tools
This chapter explores various performance tuning techniques for SQL Server, such as the options for recompiling and utilizing query store hints for optimization. The speakers engage in a lively debate over the effectiveness of common table expressions (CTEs) and their potential drawbacks, emphasizing the importance of readability and proper usage. Additionally, they express a desire for modern advancements in T-SQL, comparing its limitations with newer database systems.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
