Saskatoon SQL Server User Group

Next Meeting

Friday,

April

29

Meeting number 4

  • In-Person @ 506 25Th St E Saskatoon, Saskatchewan, Canada (map)
  • 13:30 - 16:00 (UTC-06:00) Saskatchewan
  • Language: English
  • Calendar reminder: iCal
  • RSVP: None

Hi everybody,

Meeting number 4 is scheduled and ready to rock.  The location will be same as usual (the Saskatoon Community Village) and the time will be 1:30 PM until 4:00 PM.  I am working on figuring out which room but it will either be room 204 or 206.  I will update this post as soon as I know for sure.

The topic will be:

A Tale of Two Joins: Merge vs. Hash

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 sit through 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’ll 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.

This is a video from SQL PASS 2014, but it is an interesting video and I have actually noticed the 2014 PASS videos play better on my projector (they are bigger).

PASSChapterLogo.jpg

Upcoming PASS Sponsored Events:

  • ONLINE EVENTS:

  • IN PERSON EVENTS:

  • 24 hours of PASS - here

    PASS BA Days - here
    BA Marathon - herePASS affiliated conferences - here

    And can't forget SQLSaturday (aka mini-Summit) - here

    Back to Top
    cage-aids
    cage-aids
    cage-aids
    cage-aids