T-SQL Performance Tip: Stored Procedure Names
July 29, 2019
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided.
Menu
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided.
There are many instances in which you might repeatedly use some functionality. It would be handy if you were allowed to create a function that could be used as, and
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided. ? Visit the DevX Tip Bank ?