3/26/2013 6:00 PM

Mar 26 - Physical Join Operators - PASS Summit 2011 prezo, Location: St. Michael Lutheran Church Youth Room (Door 8)


This is a previously recorded PASS Summit 2011 session.
SQL Server uses three physical join operators: Nested loops, Merge, and Hash Match.
In this session we will:

  • See how each of these operators work
  • Review their advantages and drawbacks
  • Understand some of the logic behind the optimizer’s decisions on which operator to use
  • Learn to identify common join-related pitfalls

About the Speaker
Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT. For the past 14 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. He leads the Israeli SQL Server user group (ISUG), moderates the Hebrew MSDN SQL Server support forum, and is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences. Ami speaks often at user group meetings in Israel and Europe and writes articles about SQL Server.

St. Michael Lutheran Church - Youth room - door 8
2131 Getz Rd
Fort Wayne, IN 46804

Pizza and soda is a $4.00 self pay.

Copyright 2010 fwPASS.org, All Rights Reserved