Friday, January 21, 2011
Why not to use prefix sp in store procedure
Thses prefix is used by master database so SQL server first searches in the master database and then in the current session database. So its time taken is much higher master database causes extra overhead and also get wrong result in case of same name in master database.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment