Avoid using sp_ as a prefix for stored procedures

In SQL Server, the sp_ prefix is reserved for system stored procedures. If you use sp_ prefix for your stored procedures, the name of your procedure might conflict with the name of a system stored procedure that exists or that will be created in the future, and in some cases SQL Server will execute the system procedure instead of your procedure.

Using an explicit schema qualifier when executing the stored procedure provides a slight performance advantage, because SQL Server does not have to search multiple schemas to find the procedure.