Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Dear SQL DBA
00:00
Mastering SQL Server Performance Tuning
This chapter explores the complexities and techniques of performance tuning in SQL Server, focusing on filtered indexes and the challenges of soft deletes. The speakers discuss the advantages of filtered statistics and the use of non-clustered column store indexes, while also comparing SQL Server's capabilities with modern alternatives like Snowflake. Through humor and candid insights, they critique various optimization strategies, touching on the intricacies of join hints, indexed views, and the importance of memory in enhancing performance.
Transcript
Play full episode
