Performance Tuning tips for Sql
While at work, it's not uncommon to see many WTF transact SQL used in stored procedures. After looking at various astonishing transact sql and seeing how they bring Sql Server to its knees, I realised that the fundaments of "DO'S" and "DON'TS" taught during school days are pretty much forgotten. If you're keen to fine-tune your sql queries, this is a good article.