Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Dear SQL DBA
00:00
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.
Transcript
Play full episode
