Note that naming stored procedures starting with "sp_" causes SQL Server to search master for the procedure first, causing cache misses and more expensive name resolution.

Hi Tony,

I am certainly on board with there at least being recommended conventions, realizing that most of the current generation will ignore them.

Over the years, my colleagues and I have...