Phil Scott advises us why we shouldn't prefix our stored proc names with “sp_”. Good stuff!
Stored Procedures will run fractionally slower if they start with a prefix of sp_ This is because SQL Server will look for a system stored proc first. Therefore never start stored Procedures with a prefix of sp_
This is false, SQL will look first into the current DB then it will go to look at the master if not found
That was my comment.