Don't use sp_ with stored procedures

Posted Thursday, June 21, 2007 4:20 PM by C-Dog's .NET Tip of the Day

Ok, so I thought this was on of those things that goes without saying. You know something that you expect every half decent programmer to know inately, but aparently that is not the case. Do not name your stored procedures with the prefix sp_. Honestly, I thought everyone knew this. Why do you not want to do this? It causes a CacheMiss because SQL Server always looks for stored procedures with sp_ in the Master database. So if you have things named this way, go change them so you don't look like a noob.

Besides, sp_ is considering hungarian notation, so you should know better. Here is some more info on why not to use it as well.

SQL Server Locking caused by compile locks

Read the complete post at http://www.dotnettipoftheday.com/blog.aspx?id=366