What is T-SQL Tuesday?
T-SQL Tuesday is the brain-child of MVP Adam Machanic (blog|twitter). It happens once a month on the 2nd Tuesday and is hosted by a different person in the SQL community each time. The idea is to get the SQL Community blogging on a common topic on a single day of the month after which a round-up of all the participating posts are done by the hosting blog owner to give the SQL community a one-stop shop of some great articles on a single topic.
What is the topic for July?
The topic for July is “T-SQL Best Practices”. If you work with SQL Server, then undoubtedly you would have had to write T-SQL queries atleast once or would have had to debug the seemingly useful piece of T-SQL code written by your developers to find out where the performance bottleneck or problem was. Your post for this month’s revolving blog party could be along one of the areas:
a. A set of T-SQL best practices that you follow in your shop that or you believe that should be followed always. It could be as specific as for writing only linked server queries or writing queries for SSIS packages etc.
b. An issue that you resolved because certain T-SQL best practices were not followed.
c. A workaround that you used (like query hints) to resolve an issue where T-SQL best practices couldn’t be implemented due to involvement of a third party solution.
Why did I choose this topic?
Over the years of troubleshooting SQL performance related issues, I have found on multiple occasions that the T-SQL query in question was performing badly because certain best practices for writing that piece of code were not followed and the one responsible for the development had not foreseen that such an oversight could become a bottleneck when the data or the number of users increased. So, I thought it would be a good idea to get the SQL Community’s thoughts around best practices in this area. Sometimes, the most obvious things are the easiest to overlook!
What are the Rules?
T-SQL Tuesday has some basic rules which are pretty easy to follow.
1. Your post must be published between 00:00 GMT Tuesday July 12, 2011, and 00:00 GMT Wednesday July 13, 2011.
2. Your post must contain the T-SQL Tuesday logo from above and the image should link back to this blog post.
3. Trackbacks should work, but if you don’t see one please link to your post in the comments section below so everyone can view your blog post.
Good-to-have
- Include a reference to T-SQL Tuesday in the title of your post
- Tweet about your post using the hash tag #TSQL2sDay
- Being creative always fetches brownie points and gets a smile from the reader!
So now it’s time for:
SELECT [content] FROM [dbo].[tblbrain] WHERE [content_type] = ‘T-SQL’
Before I wrap-up this post, a big thanks to Adam for letting me host T-SQL Tuesday for this month!
Comments
51 responses to “Invitation for T-SQL Tuesday #20 – T-SQL Best Practices”
Thanks Amit, that is high praise! 🙂 And thank you for hosting!
LikeLike
[…] this time around, hosted by Amit Banerjee (Blog|Twitter). The topic for the twentieth edition: T-SQL Tuesday #20 – T-SQL Best Practices. Follow the link to see all of the other contributions made by the wonderful Online SQL Server […]
LikeLike
Mine’s up, at http://sqlblog.com/blogs/rob_farley/archive/2011/07/12/my-biggest-recommendation-for-people-learning-t-sql.aspx
LikeLike
T-SQL Tuesday #20 – T-SQL Best Practices…
This first contribution to T-SQL Tuesday will be about my rules of thumb while coding T-SQL. The focus will not be on design aspects but merely on how you can write code so your co-workers and clients are able to understand what the code should be doin…
LikeLike
Here’s my entry, thanks for hosting!
http://noelmckinney.com/2011/07/t-sql-tuesday-020-best-practices/
LikeLike
[…] blog post is written in response to the T-SQL Tuesday hosted by Amit Banerjee. I know Amit personally and very big fan of his community activities. I read his blog, read his […]
LikeLike
Great great subject.
You continuously send me in my past with this subject.
My congtribution:
Once again many thanks Amit!
LikeLike
My few thoughts… http://thelonedba.wordpress.com/2011/07/12/t-sql-tuesday-20-t-sql-best-practices/
LikeLike
Remember to use your ORDER BY clause correctly.
http://richbrownesq-sqlserver.blogspot.com/2011/07/t-sql-order-by-on-select-not-insert.html
LikeLike
Thank you for your post.
LikeLike
Interesting thoughts and thank you for participating.
LikeLike
Very good advice 🙂
LikeLike
Thanks for posting.
LikeLike
Sometimes these points are not followed even though people know them. Good to have them on paper.
LikeLike
Thank you for posting.
LikeLike
[…] This post is my contribution to T-SQL Tuesday #20, hosted by Amit Banerjee (blog | twitter). This month’s topic is “T-SQL Best Practices”. […]
LikeLike
Here is mine’s. Amit thanks for gave such a great topic.
http://sqlserverblogforum.blogspot.com/2011/07/t-sql-best-practice-sql-server.html
LikeLike
Here’s mine.
http://blog.nhaslam.com/2011/07/12/t-sql-tuesday-20-its-all-about-the-files-tsql2sday/
Thanks for hosting!
LikeLike
T-SQL Tuesday #20 T-SQL Best Practices http://wp.me/pO66B-3g
LikeLike
Thanks, Amit! You can find my post here: http://mattvelic.com/tsql-tuesday-20-best-practices/
LikeLike
Amit, thank you for being the #tsql2day host, hopefully you enjoy the experience. You can find my post at http://www.sqlmashup.com/t-sql-tuesday-20-t-sql-best-practices
LikeLike
[…] month’s TSQL Tuesday is hosted by Amit Banerjee ( blog | @banerjeeamit ) and topic is TSQL Best Practices. Now, I have never taken a T-SQL class, and I am not a database developer. I have spent minimal […]
LikeLike
Here’s my contribution, in case the pingback doesn’t work. Thanks for hosting!
http://awanderingmind.com/2011/07/12/t-sql-tuesday-20-best-practices-and-those-who-dont-follow-them/
LikeLike
It’s the axe-wielding psychopath that makes it interesting, I know…
LikeLike
[…] T-SQL Tuesday #20 is hosted by Microsoft's Amit Banerjee (@banerjeeamit), and the topic he chose is T-SQL Best Practices. I like this topic choice because I have long been a proponent of using positive, consistent […]
LikeLike