I show several reasons why you should stop using the sp_ prefix on stored procedures in SQL Server, including a performance hit.