#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 · 21 Comments
Posted in: Blogging is FUN!, SQLServerPedia Syndication, The Social Web, TSQL2sDay

21 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?)


  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


    Thanks for hosting Stuart.

  6. Andy Galbraith - October 4, 2011

    Here’s my meek submission:


  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!


  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…


  12. Matt Nelson - October 4, 2011

    here is my contribution:

  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…



  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


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

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

  18. SQL SERVER - Quick Note about JOIN - Common Questions and Simple Answers - Journey to SQL Authority with Pinal Dave - February 24, 2016

    […] blog post is written in response to the T-SQL Tuesday post of JOIN. This is a very interesting subject. Years ago, I wrote my article about SQL SERVER – […]

  19. T-SQL Tuesday #23: WHERE The JOIN Ends | Bob Pusateri - SQL Server and Kindred Subjects - July 21, 2016

    […] month’s T-SQL Tuesday topic comes to us courtesy of Stuart Ainsworth (blog|@codegumbo), and is early due to the PASS […]

  20. T-SQL Tuesday #23 – Joins - Wayne Sheffield - July 26, 2016

    […] in the SQL force today… here it is the first Tuesday of a month, and we’re doing a T-SQL Tuesday. There was another recent disturbance in the SQL force when we had a T-SQL Wednesday. Oh my, the […]

  21. 2011 T-SQL Tuesdays – T-SQL Tuesday - February 24, 2017

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

Leave a Reply