THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server) and leader of the SQL User Group in Adelaide, Australia. Rob is also a Director of PASS, and runs training courses around the world in SQL Server and BI topics.

T-SQL Tuesday #43 – Hello, Operator?

June 11th is next week. It’s a Tuesday, the second Tuesday of the month, making it T-SQL Tuesday! This is your opportunity to write on a specific topic, along with countless* people from around the SQL community (* at least until the end of the day, when it will be quite easy to count how many people joined in).TSQL2sDay150x150 This month marks 3.5 years since it started, with 42 events held so far.

This month, for number 43, I’m the host. That means that I set the topic, and this blog post is the one that you need to get a comment into so that I can find your post before I collate them.

The topic is Plan Operators. If you ever write T-SQL, you will almost certainly have looked at execution plans (if you haven’t, go look at some now. I mean really – you should be looking at this stuff). As you look at these things, you will almost certainly have had your interest piqued by some, and tried to figure out a bit more about what’s going on.

That’s what I want you to write about! One (or more) plan operators that you looked into. It could be a particular aspect of a plan operator, or you could do a deep dive and tell us everything you know. You could relate a tuning story if you want, or it could be completely academic. Don’t just quote Books Online at me, explain what the operator means to you. You could explore the Compute Scalar operator, or the many-to-many feature of a Merge Join. The Sequence Project, or the Lazy Spool. You’re bound to have researched one of them at some point (if you never have, take the opportunity this week), and have some wisdom to impart. This is a chance to raise the collective understanding about execution plans!

ComputeScalarMergeJoinSequenceProjectLazySpool

So, the T-SQL Tuesday thing...

If you haven’t heard about T-SQL Tuesday before, then do this exercise with me. Do a quick search for “T-SQL Tuesday”. If you glance down the results,  you’ll see a bunch of posts either inviting people to a T-SQL Tuesday, contributing in one (the ones that contribute link back to the host), or summarising the posts. The ‘host post’ (which this month is this one!) will have a bunch of comments and trackbacks, pointing to all the contributing posts (and hopefully to the summary too). All-in-all, it makes a terrific resource about that particular subject.

So here’s what you do!

1. Some time next Tuesday (GMT) – that’s June 11th 2013 – publish your blog post. If you’re in Australia like me, GMT Tuesday runs from mid-morning on the Tuesday through to mid-morning on Wednesday. If you’re in the US, then it’ll run from Monday evening through to Tuesday evening.

2. Make sure that your post includes, somewhere near the top, the T-SQL Tuesday image (from above), with a link to this post. This helps people find the other posts on the topic, and hopefully encourages others to jump in with their own posts. If it helps, just switch to source/HTML mode, and put the following snippet in there:
<a href="http://sqlblog.com/blogs/rob_farley/archive/2013/06/02/t-sql-tuesday-43-hello-operator.aspx" target="_blank"><img alt="TSQL Tuesday" align="right" border="0" src="http://sqlblog.com/blogs/rob_farley/TSQL2sDay150x150_1B3B2D1E.jpg"/></a>

3. Come back to this post, and write a comment, providing a link to your post. That’s probably the only way I’ll know it’s there. You can tweet, sure (use the hashtag #tsql2sday), but I still might not find it.

4 (optional, but maybe worthwhile). Keep your eye out for other people’s posts, and for when I publish the summary...

That’s about it – happy writing!

Remember: 1: Jun 11 GMT; 2: Image with a link; 3: Comment below.

@rob_farley

Published Sunday, June 02, 2013 11:48 PM by Rob Farley
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Rob Farley said:

Sewing has never been my thing. I barely even know the terminology, and when discussing this with American

June 10, 2013 8:47 PM
 

Kalen Delaney said:

I’m glad there is no minimum length requirement for T-SQL Tuesday blog posts , because this one will

June 10, 2013 11:21 PM
 

Rick Krueger said:

Thanks Rob, this one was a lot of fun. Key Lookups at the Poker Table is at http://www.dataogre.com/2013/06/10/key-lookups-at-the-poker-table-tsql2sday/

June 11, 2013 12:32 AM
 

Mickey Stuewe (@SQLMickey) said:

Thanks Rob.

Mine will magically appear on my blog at midnight California, USA time. I'm too punctilious to let it out sooner...or is it my OCD tendencies. I'm not sure which. :)

http://mickeystuewe.com/2013/06/11/t-sql-tuesday-43-give-me-a-key-lookup-operator-for-1200-please/

--Mickey

June 11, 2013 12:57 AM
 

Paul White: Page Free Space said:

This is a post for T-SQL Tuesday #43 hosted by my good friend Rob Farley . The topic this month is Plan

June 11, 2013 4:00 AM
 

Matan Yungman said:

Thank you for hosting Rob.

Here is my post:

http://www.dbnewsfeed.com/2013/06/11/nested-loops-and-parallelism/

June 11, 2013 6:46 AM
 

Kathi Kellenberger said:

June 11, 2013 9:27 AM
 

Jon Morisi said:

June 11, 2013 12:38 PM
 

Bradley Ball said:

June 11, 2013 5:42 PM
 

Tamera Clark said:

June 11, 2013 7:48 PM
 

Jason said:

I know I am coming in right at the buzzer, but here is mine

http://jasonbrimhall.info/2013/06/11/t-sql-tuesday-43-hello-operator/

June 11, 2013 8:06 PM
 

Rob Farley said:

Eighteen posts for T-SQL Tuesday #43 this month , discussing Plan Operators. I put them together and

June 13, 2013 6:59 AM
 

T-SQL Tuesday #43 Table Scan in action! | Boris Hristov said:

April 14, 2014 7:47 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement