Cardinality Estimation For Local Variables And Parameters скачать в хорошем качестве

Cardinality Estimation For Local Variables And Parameters

In this video, I dive into the nuances of using local variables in SQL Server queries, particularly how they can affect cardinality estimation and query plan quality. I use a series of dynamic SQL examples to illustrate these points, showing how mixing parameters and local variables can lead to suboptimal execution plans, especially when dealing with larger datasets. By walking through several iterations of the same query, I highlight the importance of understanding how local variables impact performance and suggest alternatives for maintaining good plan reuse without the pitfalls associated with them. CHAPTERS 00:00:00 - Introduction 00:03:48 - What are Local Variables? 00:06:47 - Parameter Sniffing and Local Variables 00:10:02 - Cardinality Estimates with Local Variables 00:13:21 - Parameter Sensitive Plan Optimization in SQL Server 2022 00:14:49 - 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━