SQL Server Internals Series: Physical Join Operators

SQL Server implements three different physical operators to perform joins. In this session you'll see how each of these operators work plus its advantages and challenges. You also get to see some informative demos.

You'll learn

The logic behind the optimizer's decisions Which operator to use for various joins using (semi) real life examples How to avoid common join-related pitfalls Speaker Ami Levin is a Microsoft SQL Server MVP and a Mentor with SolidQ. For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide.http://photos4.meetupstatic.com/photos/event/c/d/6/6/event_208792582.jpeg

Levin’s areas of expertise are data modeling, database design, T-SQL and performance tuning.

Before moving to California, he led the Israeli SQL Server user group (ISUG) and moderated the Hebrew MSDN SQL Server support forum. Ami is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences. He blogs at SQL Server Tuning Blog. (http://www.dbsophic.com/SQL-Server-Tuning-Blog/Latest.html)