Merge Join in SQL Server 2012

Just like in real life, in SQL Server to execute efficiently, you need a good plan. In this video excerpt from Joe Sack's new course SQL Server: Query Plan Analysis you'll see what to look out for in Merge Joins and how to tell if your query is creating overhead you didn't intend. In the full course Joe also covers how to capture and interpret query plans, common operators and their affects on execution plans, and some noteworthy patterns to follow.

-~-~~-~~~-~~-~-
Push your limits. Expand your potential. Smarter than yesterday-
-~-~~-~~~-~~-~-