Some people prefix their stored procedure names with sp_. Some people say you should never use the sp_ prefix in procedure names. What's the real scoop?[ read entire article ]
Never might sound like a long time, but prefixing your procedure names with sp_ causes a performance penalty if the procedures exist in a database other than master. Don't do it.
Seems that using sp_ causes the optimizer to search the master database first for the stored proc before looking at the current database ...
No comments:
Post a Comment