T-SQL Tuesday #38 – Performance Resolution

TSQL2sDay150x150This month’s T-SQL Tuesday is hosted by Jason Brimhall (b | t) and is about self reflection.  This month we’re doing a little reflecting and writing about resolve, resolution, or resolute.  I recently posted some goals I had for 2013 and this dovetails nicely with my reflection of last year and my resolve to keep moving forward and push myself in new ways.  With that in mind, I have some brief thoughts about T-SQL skills resolution.

Resolution: Bringing it Into Focus

I am pretty much a self-taught T-SQL developer.  I originally started back around SQL Server 2000 and, to be honest, really didn’t know what I was doing.  Over many years I’ve been able to slowly work on my understanding of how databases work and now I program T-SQL almost every day.  I like to think that my skills are good but last week I read Aaron Bertrand’s (b | t) great post about the performance of outer joins versus other options such as not exists and I have decided that I need to challenge myself to look for better ways to improve T-SQL performance.

My core SQL concepts are pretty solid but I’d like to increase my resolution on the “extras”.  There are so many small things that can be done to increase query performance such as appropriate use of CTEs, using NOT EXISTS instead of LEFT OUTER JOIN, or better understanding what an execution plan means and how it can modified. It will take a lot of study, some experimentation, and a little bit of luck to get those extra bits of performance.  Do you have a SQL performance tip?

Related Posts

1. My Goals for 2013

2. T-SQL Tuesday #37 – Join me in a Month of Joins

14 thoughts on “T-SQL Tuesday #38 – Performance Resolution

  1. Pingback: T-SQL Tuesday #38 Recap - SQL Server - SQL Server - Telligent

  2. science cell advance

    Do you mind if I quote a few of your posts as long
    as I provide credit and sources back to your site? My blog
    is in the exact same area of interest as yours and my visitors would
    certainly benefit from some of the information you provide here.
    Please let me know if this okay with you. Thanks a lot!

  3. super Real

    It will be the right form of monetary plan that may fulfill your trip too super Real pay day loans will be the easiest strategy
    to receive a advance loan, so you will get money till payday, it doesnt matter the reason is – we supply
    short term.

  4. dsc w650 protectors microfiber

    What i do not understood is actually how you’re no longer
    actually much more smartly-favored than you might be
    now. You are very intelligent. You already know therefore significantly
    in terms of this subject, made me individually imagine it from a lot
    of varied angles. Its like women and men don’t seem to be involved unless it is something to accomplish with Lady gaga!
    Your personal stuffs great. All the time deal with it up!

  5. stardom hollywood cheats

    Angry Birds series of games are very costly. By: Aaron CruzMobile-Cell-Phone RSS Feed RSS feed for this app for
    the specific sites which offer Mobile Game development services and cell, has greatly
    restricted the development of other types and multiple effects.

    Users wish to stardom hollywood cheats hack run their business into
    games development. The sight of a client online. This means that the advertise liberty is carry on to
    a recent survey, 60% of respondents felt mobile games business will
    reach to $11 billion by 2014.


Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>