It is T-SQL Tuesday time again. To be exact, this month's T-SQL Tuesday is the 37th and with that the first in the 4th year if the blog party. Yes – that is right. The first T-SQL Tuesday round lead by Adam Machanic (B|T) himself happened exactly three years ago in December 2009.
So before I invite you to join the newest party I would like to wish all of you a Happy T-SQL Tuesday Anniversary.
As many of you know already, I decided to declare December 2012 as the month of the JOIN by writing the A Join A Day blog series. So, it should be quite obvious what this month T-SQL Tuesday is about. You guessed correctly — I would like you to join me in talking about joins. Now you might think "If Sebastian is writing 31 posts about JOINs already there is nothing left to write about." But I can assure you that there is still plenty out there. In my series I am going to cover just the basics. For example, what is a cross join or an anti-semi-join? What is the difference between a hash and a merge join? There are many things I won't be able to cover, for example how to write efficient join queries.
Your mission – should you accept – is to write about topics like the good and the bad patterns of joining you have seen out there or really anything else that comes to your mind when thinking about joins:
- Have you had to deal with a slow monster join that you were able to conquer? Let us know how you did it.
- Have you noticed a join pattern in use that is really not good for readability but you come across it time and time again? Tell us how to do it better.
- Have you discovered a really cool way of using the APPLY command instead of a JOIN to force the execution engine to utilize the existing CPU resources more effectively? We would like to hear about it.
And if you have a topic that you always wanted to write about but that is only remotely related to joins, feel free to use it anyway and make sure to tell us why you think it is related to joins.
Hope to see you (or at least your post) next week at the party.
As you can see there are a lot of topics and ideas around joins that are just waiting to be written about. I can just see that post already forming in your head. Now you just need to start writing it down.
There are a few rules and regulations that you should follow while attending this party so that nobody feels left out or mistreated.
- Your post must go live between 00:00:00 GMT on Tuesday the 11th of December and 00:00:00 GMT on Wednesday the 12th.
- Your post has to link back to the hosting blog, and the link must be anchored from the T-SQL Tuesday LOGO (found above) which must also appear at the top of the post.
- Trackbacks should work. However, all comments and trackbacks are moderated, so give me a few minutes. If you think you waited long enough and still don't see yours, leave a comment below.
And while it is not part of the official rules, I would appreciate if you would reference the A Join A Day – Introduction too:
<a href="http://sqlity.net/en/1146/a-join-a-day-introduction/">A Join A Day – Introduction</a>.
A Join A Day
This T-SQL Tuesday invite is part of my December 2012 "A Join A Day" blog post series. You can find the table of contents with all posts published so far in the introductory post: A Join A Day – Introduction. Make sure you check out that post while you are thinking about the topic you are going to write about next week.
As always, if you have any questions or comments, let me know by posting them below.
Mine is located at http://chrisyatessql.wordpress.com/2012/12/11/t-sql-tuesday-37-invite-to-join-me-in-a-month-of-joins/ Thanks for hosting
I am JOINing in on the fun!!!! Thanks for hosting!!! http://clarkcreations.net/blog/2012/12/11/tsql2sday-37-join/
Posting my trackback for my entry http://jasonbrimhall.info/2012/12/11/lets-talk-about-joins/
The trackback may work later, but my contribution is: http://www.mikedecuir.com/archive/2012/12/a-join-in-many-languages/
Here's my participation: http://blog.hoegaerden.be/2012/12/11/shall-we-join-or-shall-we-split-now/
The trackback didn't work. As usual. http://thelonedba.wordpress.com/2012/12/11/t-sql-tuesday-037-sargability-not-just-for-where-clauses/
Here is my contribution: T-SQL Tuesday #37: JOIN Formatting… It’s all about S-T-Y-L-E… http://key2consulting.com/Blogs/jbacani/2012/12/11/269/ Thanks!
Mickey's post: RIGHT JOIN, LEFT JOIN, raw, raw, raw: http://mickeystuewe.com/2012/12/11/t-sql-tuesday-37-right-join-left-join-raw-raw-raw/
In case the trackback won't work - http://www.dbsophic.com/EasyBlog/Entry/sql-server-tuning/a-month-of-joins-t-sql-tuesday-37.html Thanks for hosting!
Thanks for hosting! My blog post is at http://alandykes.com/2012/12/11/t-sql-tuesday-37-join-me-in-a-month-of-joins/
Thanks for hosting. [Blog] Update Table Based on a JOIN http://lnkd.in/JVAsxA
Just in case the trackback doesn't get picked up: http://www.dataogre.com/2012/12/11/left-join-location-location-location-tsql2sday/
http://mattvelic.com/tsql-tuesday-37/ - Thanks for hosting!
Almost forgot, but my post can be found here: http://devjef.wordpress.com/2012/12/11/t-sql-tuesday-37-join-me-in-a-month-of-joins/ Thanks for hosting this month! :)
Mine is at http://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx. Thanks for hosting. :)