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


  
 Sponsors Minimize

PASSChapterLogo100.jpg

sql_micro_sm.gif

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

Topic:

 

A Tale of Two Joins: Merge vs. Hash

Date:

 

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

Location:

 

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

Speaker:

 

Luke Jian

Abstract:

 

 

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.

 

Bio:

 

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.

Sponsor:

 

 



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