I should’ve looked the other way

October 16, 2011

The words for that song I did at the PASS Summit 2011 are as follows. On the Friday, I stopped where the bridge starts. Various recordings of it are making it to YouTube, such as here, where the song starts around 2:20 in.

I should’ve looked the other way

Verse 1:
My query sucks – it takes too long
So long I wrote this song
The plan’s not big – it ain’t a giant
And yet I have an angry client
Performance now has made her weary
So I’ve come in to fix her query
I promise I won’t ever fail her
Say “Trust me, love, I’m from Australia!”

I need to find you
But I don’t want to search every row
My predicate’s residual
My seek just runs too slow
I thought I’d caught a glimpse of you
Been searching for all day
But all along, I’d done it wrong
I should’ve looked the other way

Verse 2:
A trace is on, I know the reads
That fetch the bytes the query needs
There’s spooling from a CTE
They’ve got recursion needlessly
I need to dig a little further
I worry there might be a cursor
The DBA has the plan_handle
He says it’s not corrupt, he knows Paul Randal!

Repeat chorus

There is an index covering predicates with keys
But my developer has used inequalities
There is a range scan
Hiding truth
Hiding cost
Hiding you…

Repeat chorus x2

I should’ve looked the other way

Β© 2011 Rob Farley πŸ˜‰


This Post Has 12 Comments

  1. Cindy Gross

    That is a great song and your performance Friday was great… And performant.

  2. Nigel Sammy

    You can hear him sing the entire song in the lightning talks recording!

  3. Reinaldo

    The performance at SQL PASS was great. Thanks for sharing the lyrics

  4. Todd Everett

    Ok that is just awesome!

  5. andyleonard

    Great job Rob! Buck did an awesome job backing you up, too!

  6. davepen

    I haven’t been to PASS in more than 6 years.
    No company I’ve worked for since then will pay for it.
    PASS will eventually become the conference of consultants and media-supported folks.
    I’m glad you’re having a good time out there.

  7. Rob Farley

    Thanks everyone. πŸ™‚
    @davepen : drop me a line and let’s talk about what would persuade your boss to send you there. If he doesn’t think it’s worthwhile, then let’s make some changes so that it is. You should see an address on the right of the blog site. I’m happy to discuss it with your boss as a board advisor. We can also try to see what else PASS could do to provide local support for you and your company. So seriously – drop me a line and tell your boss that you have the ear of someone on the board.

  8. Kitty Sethi

    I attended your pre-coference class and enjoyed.
    The song was great and thanks for sharing lyrics.
    Is it OK with you if we play/sing this at our Quaterly IT meeting.

  9. AndyG (@DBA_ANDY)

    Wasn’t there but saw you on the notlivestream – fun stuff!

  10. Rob Farley

    Now that’s a request I wasnt expecting.
    Sure, no problem.

  11. Aditya

    Awesome stuff Rob!!!!!!!
    He says it’s not corrupt, he knows Paul Randal!
    hahahaha..superb lyrics… Wish Im in America and I could attend PASS.
    I will do it one day and sing along with u πŸ™‚

  12. ALZDBA

    really enjoyed the performance at sqlpass.
    Great geeky lyrics.
    Smooth πŸ˜‰

Leave a Reply

LobsterPot Blogs

Blog posts by Rob Farley and other LobsterPot Solutions team members.