July 29, 2019

Creating User Defined Functions

July 29, 2019

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

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.

Tip: T-SQL Performance–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. ? Visit the DevX Tip Bank ?