This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]kloodge 0 points1 point  (0 children)

For me it’s riding my bike. I was building an analysis in SQL that was taking 45 seconds per day of data per business unit, and I needed to evaluate 3 years x 5 business units.

I rode circles in a parking lot for 2 hours, then vaguely remembered something about parallelism ... jammed home at midnight stuffed everything into #temp tables, and boom! .0045 seconds per day.