Never use prefix “sp_” in the stored procedure name in the sqlserver Database

If a stored procedure name begins with “SP_,” then SQL server first searches in the master database and after that in the current session database.
 
So Searching in the master database causes extra overhead and even a wrong result if another stored procedure with the same name is found in master database.So the performance will degrade
Ebook Download
View all
Learn
View all