SQL Server Performance Office Hours Episode 91
In this video, I dive into a series of questions from viewers, covering everything from diagnosing query timeouts to the nuances of using 'BETWEEN' versus '=' and '' for date ranges, and even delve into the complexities of parallel execution plans and Query Store. I share practical advice on how to approach these issues, offering insights that can help you optimize your SQL Server performance. Whether you're dealing with tricky query timeouts or simply want to improve your T-SQL skills, there's something in this video for you. If you have any questions or topics you'd like to see covered, head over to the video description and drop them in the comments. As always, if you enjoy the content, don't forget to like, subscribe, and share with your friends. CHAPTERS 00:00:00 - Introduction 00:04:30 - Query Timeouts When Blocking Isn't the Cause 00:06:46 - Using BETWEEN for Date Ranges 00:07:52 - Slow Parallel Repartition Streams and CXPACKET Waits 00:10:32 - Parallel Page Supplier, Row Distribution, and Memory Grants 00:12:28 - When Query Store Hides Real Problems 00:15:53 - Wrap-Up ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ FREE SQL SERVER MONITORING & Plan Analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━ https://github.com/erikdarlingdata/PerformanceMonitor https://github.com/erikdarlingdata/PerformanceStudio https://plans.erikdarling.com/ ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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