SQL

NULLIF  is a function that compares two values.  If the two values are the same, then the result of the operation is a Null matching the dat...

In a stored procedure each query has to be optimized. There is one performance feature with stored procedures which goes beyond queries: slo...

DECLARE @TableName sysName DECLARE @WhereClause VarChar(1024) DECLARE @ColumnList NVarChar(4000) DECLARE @ColumnName SysName DECLARE @Co...

The fill-factor option is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor ...

Here is a function to compute the age of a individual, by passing Birth Date and As On Date. CREATE FUNCTION [dbo].[fn_GetAge] ( @DOB DATET...