SQL Server Performance Office Hours Episode 59

## Summary In this video, I dive into some of the most pressing questions submitted by the SQL Server community, covering topics ranging from parameter sniffing and implicit conversions to the impact of max degree of parallelism on blocking and the common mistakes people make when reading execution plans. I also delve into the trade-offs between query compilation and execution time, suggesting strategies like dynamic SQL and conditional recompilation to optimize performance. Whether you're a seasoned SQL Server pro or just starting out, there's plenty to learn and ponder as we tackle these real-world issues head-on. Don't forget to hit that like button, subscribe to the channel, and share this video with your SQL Server colleagues to help spread the knowledge and keep the SQL community informed and engaged. ## Chapters - **00:00:00** - Introduction - **00:01:15** - Query Compilation vs Execution Time - **00:04:07** - Lowering MAXDOP Reduced CX Costs but Blocking Got Worse - **00:07:29** - Top Three Mistakes When Reading Execution Plans - **00:10:12** - Query Compilation vs Execution Time - **00:13:50** - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️‍♂️ FREE SQL SERVER MONITORING & Plan Analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━ https://github.com/erikdarlingdata/PerformanceMonitor https://github.com/erikdarlingdata/PerformanceStudio ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY SQL Server Performance Engineering Course https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING Learn T-SQL with Erik https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL Everything Bundle: https://training.erikdarling.com/?coupon=SPRINGCLEANING ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlconsulting ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member https://www.youtube.com/@ErikDarlingData/join