re: SQL 201: 10 Ways to Tweak Slow Running Queries VIEW POST

TOP OF THREAD FULL DISCUSSION
re: You could make a lifelong career by taking this one article out on the road and doing a series of day-long workshops on these tips and advice in co...
 

SELECT * on whole multi-year monthly snapshot tables which are aliased and then joined back to themselves with no WHERE clause on either side. And people wondered why it took hours to run (and eventually fall over).

OMG! :D

code of conduct - report abuse