Going Deeper Into Joins

Most people understand Joins in T-SQL - it's a 101 thing. But there is so much more to them, and understanding what's really going on can help you write better T-SQL and troubleshoot more effectively. This is definitely not a level 100 talk.

In this talk, Rob will look at the different types of physical join and the different types of logical join - even accidental joins, when you really didn't mean to join anything at all. Examples will be given of when these joins are used effectively and when they are used badly, showing you clues to help you determine when things are good and when they're bad.

About the presenter

This meeting marks six years that Rob Farley has run the Adelaide SQL Server User Group.

Rob is the owner and principal consultant of LobsterPot Solutions Pty Ltd, a local consulting firm specialising in SQL Server and Business Intelligence. Rob is a Microsoft Certified Trainer, a five-time recipient of the SQL Server MVP award from Microsoft, and has recently been asked to join to the PASS Board of Directors. He was the author of two chapters in SQL Server MVP Deep Dives and one in SQL Server MVP Deep Dives 2.

He blogs at http://sqlblog.com/blogs/rob_farley, tweets at http://twitter.com/rob_farley, and has a LinkedIn profile at http://au.linkedin.com/in/robfarley. His company website is at http://www.lobsterpot.com.au.