Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Dear SQL DBA
00:00
SQL Server Performance Tuning Insights
In this chapter, the speakers evaluate various SQL Server performance tuning tools, contrasting their experiences with Common Table Expressions (CTEs) and Resource Governor. They share a newfound appreciation for the Resource Governor's memory management, while expressing disappointment in CTEs' performance contributions. The discussion also covers advanced tuning techniques, table variables versus temp tables, and humorous anecdotes about technical challenges and recent SQL Server features.
Transcript
Play full episode
