#TSQL2sDay T-SQL Tuesday 23–Early edition

T-SQL Tuesday Logo

 

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.

September 27, 2011 · stuart · 17 Comments
Posted in: Blogging is FUN!, SQLServerPedia Syndication, The Social Web, TSQL2sDay

17 Responses

  1. Rob Farley - September 29, 2011

    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

  2. Tracy McKibben - October 3, 2011

    My contribution to T-SQL Tuesday: http://www.real-sql-guy.com/2011/09/t-sql-tuesday-23-nested-joins.html

  3. Pinal Dave - October 3, 2011

    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/

  4. Rob Farley - October 3, 2011

    Here’s mine: http://sqlblog.com/blogs/rob_farley/archive/2011/10/04/joins-without-join.aspx

  5. Rich Brown - October 4, 2011

    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.

  6. Andy Galbraith - October 4, 2011

    Here’s my meek submission:

    http://nebrasql.blogspot.com/2011/10/t-sql-tuesday-23-respect-your-joins.html

  7. Thomas Rushton - October 4, 2011

    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/

  8. Wayne Sheffield - October 4, 2011

    Here’s mine: http://blog.waynesheffield.com/wayne/archive/2011/10/t-sql-tuesday-23-joins/

  9. Bob Pusateri - October 4, 2011

    Here you go – thanks for the great topic!

    http://www.bobpusateri.com/archive/2011/10/t-sql-tuesday-23-where-the-join-ends/

  10. Richard Douglas - October 4, 2011

    Here’s my contribution: http://sql.richarddouglas.co.uk/archive/2011/10/t-sql-tuesday-23-key-lookups.html

  11. Robert Matthew Cook - October 4, 2011

    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

  12. Matt Nelson - October 4, 2011

    here is my contribution:
    http://nelsonsweb.net/2011/10/t-sql-tuesday-23-joins/

  13. Brad Schulz - October 4, 2011

    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

  14. Ricardo Leka - October 4, 2011

    Hi, my contribution http://leka.com.br/2011/10/04/t-sql-tuesday-23-joins/

  15. KenJ - October 5, 2011

    Thanks for hosting!

    Running a bit late, but here’s what I have – http://kenj.blogspot.com/2011/10/join-me.html

  16. Muthukkumaran Kaliyamoorthy - October 5, 2011

    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/

  17. T-SQL Tuesday Topics | Voice of the DBA - February 5, 2014

    […] T-SQL Tuesday #023 – Joins (summary) […]

Leave a Reply