Art of the DBA Rotating Header Image

Invitation to T-SQL Tuesday #33 – Trick Shots (#tsql2sday)

For a while, I was in an amateur pool league.  No, not the one involving water and swimming, but where you try to sink balls into pockets.  It was a lot of fun and is a challenge both for your motor skills as well as your strategy.  I still shoot from time to time, as well as hang out with my old pool buddies.

One thing guys would get into is trick shots.  Two and three rail bank shots, masse shots, or jumping the cue ball to hit the target.  Most of these shots weren’t tournament legal, but they were fun to try and nice to impress the ladies.  More than that, they were a tool to teach you the physics of your pool game.  You could see how throw and English could affect your shot, or how balls would behave after impact.

Just like so many other things I do in my life, the trick shot lessons translate over to SQL Server.  How many times have we built something neat or puzzled out a particular bit of logic that, while it may not have been particularly useful, taught us about how SQL Server behaves.  This month’s T-SQL Tuesday is all about this and the assignment is two-fold:

  1. Show us a cool trick or process you developed, maybe a DMV you used or some reporting logic you created.  It doesn’t have to be useful, just something that you thought was pretty neat.
  2. Tell us what you learned from this trick.  Is it something about an oddity in SSRS?  Maybe with the query processor?  Whatever you did, tell us how it gave you insight in to how SQL Server works.

Now with that out of the way, keep in mind the ground rules for T-SQL Tuesday:

  • Posts must be made between August 14, 2012 00:00:00 GMT and August 15, 2012 00:00:00 GMT.
  • Your post should contain the T-SQL Tuesday logo and a link back to this post.
  • If you don’t see your post in trackbacks (give me ~30 minutes to approve), post a link to your post in the comments of this post.

If you’re on Twitter, you can follow T-SQL Tuesday at #tsql2sday.  Follow it, it’s a great way to see what everyone is writing about!  And if you’re interested, Adam Machanic(b|t) handles the T-SQL Tuesday hosting list, contact him if you have an idea for one.


  1. […] T-SQL Tuesday #33 – Trick Shot […]

  2. […] Invitation to T-SQL Tuesday #33 – Trick Shots – Get involved in the community and share your thoughts/stories/insights through T-SQL Tuesday, this month hosted by Mike Fal (Blog|Twitter). […]

  3. Hi Mike,

    The dates in your post are incorrect. It should be August 14, 00:00:00 GMT through August 15, 11:59:59.99 GMT. Hopefully most readers will understand this anyway, but you might want to fix it just in case :-)


    1. Mike Fal says:

      Whoops! Corrected.

  4. […] T-SQL Tuesday time again, and this is my post for #33. The host is Jeff Smith and his topic is Trick Shots, which is an interesting one. I’m not a tricky guy, and I tend to lean towards common, practical […]

  5. […] T-SQL Tuesday again, and this month’s gracious host is Mike Fal (Blog | Twitter), urging us to deliver wonderful stories about SQL Server trick shots. […]

  6. […] month’s T-SQL Tuesday is hosted by Mike Fal (Blog | Twitter).  For this edition, the invitation was to show a cool trick you developed in SQL Server and explain how it helped you learn about how […]

  7. […] month’s T-SQL Tuesday is being hosted by Mike Fal (blog | twitter), and the topic is Trick Shots, where we’re invited to tell the community about some solution we used in SQL Server that […]

  8. […] for joining me this month, where I not only get to contribute but also host T-SQL Tuesday. I’m excited to see what other things our peers can teach us about the things they’ve […]

  9. Chris Shaw says:

    My post…

    Thanks for the question, it was a good one.

  10. […] is T-SQL Tuesday #33 hosted by Mike Fal.  The topic is SQL Server – Trick Shots.  This assignment involves blogging about a cool process or trick you implemented that is […]

  11. My Post:

    It was my first one and I really enjoyed the topic!

  12. […] is T-SQL Tuesday #33 hosted by Mike Fal.  The topic is SQL Server – Trick Shots.  This assignment involves blogging about a cool process or trick you implemented that is related […]

  13. […] T-SQL Tuesday #33 – Trick Shot (roundup) […]

  14. […] Aug – T-SQL Tuesday #33 – Trick Shot (roundup) […]

Leave a Reply

Your email address will not be published. Required fields are marked *