Tuesday, August 4, 2015

level up: In my last 10 minutes at work, solved a problem in SQL that would have taken hours or days to solve in...

level up: In my last 10 minutes at work, solved a problem in SQL that would have taken hours or days to solve in Excel.

A year ago, my tool of choice would have been Excel. This component was being done in Excel -- and Access -- by other analysts, who asked me for help at the last minute.

In SQL, it took longer to load the data than to do the required operations -- basically a join. Sent it back out, and spent more time explaining how I got there than I spent thinking about the query.

And I'm home in time for Jeopardy.

I am so filled with energy at that accomplishment. I'm not certain I'm getting that across -- this was glorious!

3 comments: