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), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and runs training courses around the world in SQL Server and BI topics.

I should've looked the other way

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!"

Chorus:
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

Bridge:
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 ;)

@rob_farley

Published Sunday, October 16, 2011 6:08 AM 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

 

Cindy Gross said:

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

October 15, 2011 2:25 PM
 

Nigel Sammy said:

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

October 15, 2011 2:28 PM
 

Reinaldo said:

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

October 15, 2011 3:03 PM
 

Todd Everett said:

Ok that is just awesome!

October 15, 2011 7:51 PM
 

andyleonard said:

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

:{>

October 16, 2011 2:34 PM
 

davepen said:

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.

October 17, 2011 12:00 AM
 

Rob Farley said:

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.

October 17, 2011 1:10 AM
 

Kitty Sethi said:

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.

Thanks

October 18, 2011 12:08 PM
 

AndyG (@DBA_ANDY) said:

Wasn't there but saw you on the notlivestream - fun stuff!

October 18, 2011 4:20 PM
 

Rob Farley said:

Kitty,

Now that's a request I wasnt expecting.

Sure, no problem.

Rob

October 18, 2011 4:38 PM
 

Aditya said:

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 :)

-Aditya

October 21, 2011 1:03 AM
 

ALZDBA said:

really enjoyed the performance at sqlpass.

Great geeky lyrics.

Smooth ;-)

October 21, 2011 4:03 PM
 

Rob Farley said:

So far, my three PASS Summit experiences have been notably different to each other. My first, I wasn’t

November 13, 2012 1:05 AM
 

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

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

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