Session Details

Physical Join Operators  

Level :
Intermediate
Date :
2:45 PM Sunday
Room :
5501
Interested : (-) - Registered : (16)
Tag(s) :
ADD TO CALENDAR...

Presentation

SQL Server implements three different physical operators to perform joins. In this session, we will examine how each of these operators works, including its advantages and challenges. Using real life examples, we will better understand the logic behind the optimizer’s decisions on which operator to use for various joins. Finally, we will learn how to avoid some common join related pitfalls and how to get better performance from our queries.

The Speakers

img

Ami Levin

Ami Levin is a Microsoft SQL Server MVP since 2006, with over 25 years of experience in development and IT. For the past 15 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide. Ami's areas of expertise are data modeling, database design, T-SQL, and performance tuning. Ami currently resides in California and works as a data tier architect for Tachyus.
  • Not Interested
  • Interested
  • Attending

SPONSORS List