4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Physical Join Operators

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.
Presented by Ami Levin at SQLBits VII
  • Downloads
  • SpeakerBIO
    ami_levin.jpg

    Ami Levin is a Microsoft SQL Server MVP, with over 20 years of experience in the IT industry. For the past 14 years he has been consulting, teaching and speaking on SQL Server worldwide. He manages the Israeli SQL Server user group, moderates the local MSDN SQL Server support forum, and is a regular speaker at Microsoft conferences. Levin’s areas of expertise are data modeling, database design, T-SQL and performance tuning. He blogs and publishes regularly on sql-server-tuning.com.

    http://il.linkedin.com/in/levinami
  • Video