DBA bitches about one of our developers SQL... implement changes... deploy... now it takes 12 minutes... up from 40 seconds... good job!

Whoa! What happened??

what database? Did the DBA change the developers SQL or make DB config changes?

I'd love to see the SQL in question. Were the results of both queries equivalent?

The DBA optimised the script to suit their best practices... results were the same... I wish we had access to the stats because the IOPs probably went throught the roof...

Don't get me wrong, I love learning but sometimes book knowledge is just that...

Besides, that sql was being called by multiple threads in the app... and changed our CTE to global temp tables ala ##...

Adding 11 minutes to the execution time, yep. That's one hell of an optimisation. Did he revert it after that? XD

Yep... but we had to explain why 😎

Ah.. SQL Server