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
Good Hunting!
AJ Ahrens
webmaster@kritter.net