Silicon Valley Microsoft Data Platform Meetup

Name: SQL Server Internals Series: Physical Join Operators
Start: 2013-04-17T01:30:00Z
Location: Microsoft

SQL Server Internals Series: Physical Join Operators

Apr 16, 2013 · 6:30 PM
Microsoft

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.

Hit enter to add your reply

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?

0 · June 11, 2014
Razi

Excellent presentation and the content was in depth ...

0 · 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.

0 · 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.

0 · February 28, 2013