In an attempt to try a different approach, here’s a three-minute video explanation of how the different physical join operators in SQL Server work and why you would choose one over the other.

More reading

I’ve written a few blog posts on join operators befores, so if this video wet your appetite, here’s some recommended reading:

• Reading a query plan
• JOIN types and performance
• HASH JOIN deep-dive

I’d love to hear what you think of the short video format! Please leave feedback in the comments below or on Twitter.