November 15, 2002 at 8:23 pm
I have a recollection of reading somewhere that the "sp_" prefix should be avoided when naming stored procedures since sql server would then first check the master database . Is this indeed the case?
Thanks.
November 15, 2002 at 11:31 pm
Yes. If you are creating stored procedures in user databases, avoid sp_ because it will cause a performance hit. It has to do with how SQL Server looks for the execution plan. I have an article which goes into more details:
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp
Also, see the recent sp_ search order article by Antares:
http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply