I 100% agree with the NEVER use sp_ as the first 3 characters. I use the spA, spD, spU etc... I was lucky enough to not fall into that trap. The Lead DBA I worked for kept our team up-to-date with issues like this and how to use performance tools etc....

I have known developers that have done this (used sp_) and have had to re-write because the code being fired wasn't correct and due to the performance hits.

😀

Thanks,

AJ

AJ Ahrens

SQL DBA

Custom Billing AT&T Labs