Of RECOMPILE Hints And Query Store: Where Are My Parameter Values?! скачать в хорошем качестве

Of RECOMPILE Hints And Query Store: Where Are My Parameter Values?!

In this video, I dive into the world of query tuning with a focus on recompile hints and Query Store. I share my experiences working with performance tuning in SQL Server, emphasizing how Query Store is an invaluable tool for identifying slow queries. However, I also highlight some frustrations, particularly when dealing with temp tables or table variables, where you can't easily see the full stored procedure plan in query store. To illustrate these points, I walk through a demonstration using Stack Overflow and a custom stored procedure to compare plans with and without recompile hints. This video aims to provide practical insights into troubleshooting and optimizing queries, even if it means navigating through some complex execution plans. CHAPTERS 00:00:00 - Introduction to Query Tuning and Plan Differences 00:02:34 - Using QuickieStore for Query Analysis 00:06:55 - Exploring the First Query Plan Without Recompile Hint 00:08:51 - Parameter Values in Non-Recompile Queries 00:10:06 - Understanding Option Recompile Behavior 00:10:46 - Challenges with Large Plans and Multiple Predicates 00:11:35 - Conclusion and Thank You ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━