Time once again for another edition of T-SQL Tuesday! What’s that, you say? Early? Why yes, indeed. Due to the potential schedule of conflict of PASS’s Summit 2011 occurring on the second Tuesday of October (the normal date for T-SQL Tuesday), I’ve gotten special permission to bump it up a week.
To participate in this month’s T-SQL Tuesday, your post must go live between midnight UTC on Tuesday, October 4, 2011 and midnight UTC on Wednesday, October 5.
Your post needs to link back to this blog, and if you use the image, anchor it to this post. Make sure you leave a comment or a trackback to this post (so I can find it later, when I write up the summary).
Topic d’jour? JOINS (I’m in a fundamentals mood lately). Note that I also like creative and esoteric posts, so if you can find a way to apply SQL as a metaphorical language for community activity, I’ll read it and enjoy it. If you just want to tell me in a simple fashion the difference between a HASH and MERGE join, I’m cool with that, too.
Do me a favor, though, and please spread the word about the early date. Looking forward to reading your submissions.
Wow – glad I stumbled across this. I did a presentation on joins at my user group the day you posted this! http://adssug201109.eventbrite.com
I’m sure I’ll be able to write plenty. Trying to get stuff done this side of Summit might be tricky though.
Thanks for hosting though, and for picking such a good post. I feel an Anti-Semi post coming up, assuming one doesn’t already exist before I get mine published. (See what I did there?)
Rob
My contribution to T-SQL Tuesday: http://www.real-sql-guy.com/2011/09/t-sql-tuesday-23-nested-joins.html
Great subject and I am sure this will bring some interesting conversation – here is my submission – http://blog.sqlauthority.com/2011/10/04/sql-server-quick-note-about-join-common-questions-and-simple-answers/
Here’s mine: http://sqlblog.com/blogs/rob_farley/archive/2011/10/04/joins-without-join.aspx
My contribution to T-SQL Tuesday #23
http://richbrownesq-sqlserver.blogspot.com/2011/10/t-sql-helping-optimiser-can-hinder.html
Thanks for hosting Stuart.
Here’s my meek submission:
http://nebrasql.blogspot.com/2011/10/t-sql-tuesday-23-respect-your-joins.html
Here’s my first TSQL2sday for a while… http://thelonedba.wordpress.com/2011/10/04/t-sql-tuesday-23-non-ansi-joins-discontinued-in-denali/
Here’s mine: http://blog.waynesheffield.com/wayne/archive/2011/10/t-sql-tuesday-23-joins/
Here you go – thanks for the great topic!
http://www.bobpusateri.com/archive/2011/10/t-sql-tuesday-23-where-the-join-ends/
Here’s my contribution: http://sql.richarddouglas.co.uk/archive/2011/10/t-sql-tuesday-23-key-lookups.html
Stuart, thank you for hosting #tsql2sday and selecting a fundamentals topic.
Here is my contribution…
http://www.sqlmashup.com/t-sql-tuesday-23-joins-tsql2sday
here is my contribution:
http://nelsonsweb.net/2011/10/t-sql-tuesday-23-joins/
Thanks for hosting, Stuart! And thanks for choosing a topic that was a good catalyst for me to come back after a long absence.
Here you go…
http://bradsruminations.blogspot.com/2011/10/t-sql-tuesday-023-flip-side-of-join.html
–Brad
Hi, my contribution http://leka.com.br/2011/10/04/t-sql-tuesday-23-joins/
Thanks for hosting!
Running a bit late, but here’s what I have – http://kenj.blogspot.com/2011/10/join-me.html
Thanks you’re in fundamentals mood lately 🙂
Here’s mine
http://www.sqlserverblogforum.com/2011/10/merge-join-vs-hash-join-vs-nested-loop-join/