The Query of Despair
Oh man. I know I've encountered something like this before. So many developers have absolutely no experience writing decent SQL. Its getting even worse these days with the prevalence of ORMs in all the big frameworks. When they do have to actually write a query, they just throw syntax together until it works, even if it ends up looking like this and taking 18 hours to run:
http://thedailywtf.com/Articles/The-Query-of-Despair.aspx
The Query of Despair - The Daily WTF
The Query of Despair. 2011-10-24. by Alex Papadimoulis in CodeSOD (204 Comments). Jeroen's colleague had the misfortune of being assigned to debug an intermittent, unspecified error in the one of ...
Comments Post a Comment
I see your six page query and raise you to twenty.
We really have a client who has a twenty page query.