A Little About Improving Modification Query Performance In SQL Server скачать в хорошем качестве

A Little About Improving Modification Query Performance In SQL Server

In this video, I dive into a common query plan pattern that can impact performance during modification queries. After giving my usual pre-video disclaimer about my haircut and setup, I walk through an example using the Stack Overflow 2013 database to illustrate how a single-threaded query with an eager table spool can significantly slow down updates. I explain why this happens and discuss alternative methods like using temp tables or automatic phase separation via hash joins to improve performance. By breaking up the process, we can avoid the inefficiencies of the eager table spool and achieve better overall query times. CHAPTERS 00:00:00 - Introduction 00:02:34 - Manual Phase Separation Example 00:06:59 - Automatic Phase Separation Example 00:11:27 - Comparison of Query Plans and Performance 00:14:40 - Key Points for Tuning Modification Queries 00:16:58 - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata   ━━━━━━━━━━━━━━━━━━━━━━━━━━