DATALENGTH is a function that returns the number of bytes used to represent any expression. This looks similar to LEN function that helps in identifying
Category: RDBMS
SQL Server Identity Functions
Identity values are handled by a number of functions in Microsoft SQL Server. The functions assist in establishing the automatic sequential value for table rows,
Grouping and Subtotals the rows in SQL Server
During data analysis, data analysts must categorize data into categories so that different aspects of the information may be displayed in a more understandable manner.
Configuration Functions in SQL Server
The following are the list of configuration commands that helps to identify the configured settings information of current instance, in SQL Server. @@DATEFIRST This function
First_Value, Last_Value vs Lead, Lag in SQL Server
The First_Value function in SQL Server returns the first value in an ordered set of values and the Last_Value function returns the last value in an ordered set of
COUNT_BIG function in SQL Server
COUNT_BIG is similar to the COUNT function. The only difference between these functions is the data types of their return values. COUNT_BIG always returns a
Big Data & SQL 