Geek City: Join With Me!

re: Geek City: Join With Me!

Rob Farley — Fri, 15 Feb 2013 00:18:19 GMT

Hi Kalen,

Nice post. Reminded me a little of one of mine from December.

http://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx

Great to know that we get our interest piqued by similar things. :)

Rob

re: Geek City: Join With Me!

Adam Machanic — Fri, 15 Feb 2013 14:53:13 GMT

Hi Kalen,

Just to set the record straight, the graphical plan change came in 2005. In 2000 it still looked like this:

http://blogs.msdn.com/cfs-filesystemfile.ashx/__key/communityserver-components-postattachments/00-00-65-26-24/bookmark_5F00_lookup_5F00_2000.PNG

(Image from Craig Freedman's blog post in which he described the 2005 change -- which is one of the best plan changes ever made, in my humble opinion: http://blogs.msdn.com/b/craigfr/archive/2006/06/30/652639.aspx )

re: Geek City: Join With Me!

Kalen Delaney — Fri, 15 Feb 2013 17:09:57 GMT

Aack! I thought about this long and hard, but I admit, I didn't try looking it up. I thought the change happened before XML plans were introduced, which was in 2005. And I think it's an awesome change too... when I said in the post that I have come to appreciate it, I meant that I REALLY love it!

Thanks Adam....