SQL Server Performance Problems When Joins Have No Equality Predicate скачать в хорошем качестве

SQL Server Performance Problems When Joins Have No Equality Predicate

In this video, I delve into the world of non-equijoin queries in SQL Server, specifically focusing on nested loops joins without equality predicates. These types of queries can cause significant performance issues, and I explore why they are problematic, especially when dealing with large datasets or specific data distributions. I also share practical solutions to mitigate these issues, including the introduction of computed columns for sargable equality predicates and the use of hints like 'FORCE ORDER' to improve query plans. By understanding the nuances of these queries, you can better optimize your SQL Server performance and avoid those dreaded 20-minute execution times. CHAPTERS 00:00:00 - Introduction 00:00:42 - Performance Problems Overview 00:01:03 - Membership Sign-Up Mention 00:02:15 - Erik Darling's SQL Server Experience 00:02:40 - Low-Cost Training Offer 00:03:07 - Upcoming Events 00:04:06 - Parallel Nested Loops Queries 00:05:08 - Query Plan Analysis 00:06:39 - Specific Example Query 00:07:36 - Query Execution Time 00:10:01 - Table Spool Explanation ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━