[thelist] MSSQL proc naming (was re: Comma delimited string in SQL)

[Paul Cowan]

rudy wrote:
> but do not name your procedure starting with sp_

Not sure whether rudy's saying this for this reason, or whether he just
doesn't like using prefixes (or both), but this is worth being a:

<tip type="SQL Server" author="Paul Cowan">
Don't name your MS SQL Server stored procs with an sp_ prefix. SQL
Server will assume that it's a system-level stored proc, and try
and look for it in the master database, leading to an extra
cache miss and slightly longer execution time.

More detail at
http://support.microsoft.com/support/kb/articles/q263/8/89.asp
</tip>