Tuesday, November 25, 2014 ..:: Home ::.. Register   Login

 Sponsors Minimize



SQL training resource

 Welcome Minimize

Welcome to Chi-SSUG!

Please click here for general group information.  Also follow us on twitter at @ChiSQL or our hashtag #ChiSQL.  We look forward to seeing you at our next meeting!

 Next Meeting Minimize



A Tale of Two Joins: Merge vs. Hash



Thursday, October 9th, 2014 @ 5:30 PM
(You must RSVP by 4:00 PM, the Tuesday prior to the meeting to attend)



Microsoft Technology Center, 200 East Randolph Drive, Suite 200 Chicago, IL 60601



Luke Jian




A good understanding of join algorithms is essential in diagnosing and fixing issues related to bad query plans. However, one of today’s realities is that a lot of database professionals do not have a computer science degree and didn't attend a formal “Introduction to Relational Databases” course.  This session seeks to fill in some of the gaps that might exist by looking in-depth at the three types of join operations. We will visualize how the join operations’ algorithms work so you can understand how query plans are computed, and then we'll look at why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. You’ll see through demonstrations that empirical cost calculations are similar to what the query optimizer actually returns.




Luke Jian is Senior Solutions Architect with Physicians Interactive in Libertyville, a leading resource for Healthcare information, medication samples, and mobile decision support tools for medical professionals. He has over 15 years of experience in database system optimization on SQL Server and Oracle, as well as an extensive understanding of IT infrastructure and SDLC.




Availability Groups versus Clustered Instances of SQL Server

Availability Groups versus Clustered Instances of SQL Server

Copyright 2008 by PASS Chapters Portal   Terms Of Use  Privacy Statement