addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

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.

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.

 

Join or login to comment.

  • Pavan

    How effecient is it to programatically retrieve a varying set of ID's and use it within an IN operator as one of the conditions for an Inner JOIN.. against...Having a separate query resulting into these ID's and joining with the existing relations within INNER JOIN?

    June 11, 2014

  • Razi

    Excellent presentation and the content was in depth ...

    April 16, 2013

  • James M.

    Had been a member of BAADD back in 1991 or so. Mostly meetings were too far way. I am looking forward to a Silicon Valley group for MS SQL SERVER.

    April 6, 2013

  • shahaji g.

    I had attended the last SQLSaturday event and I loved it. I would like to know little more about this meetups agenda.

    February 28, 2013

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy