Guid is a 16-byte binary data type that is globally unique. GUID stands for Global Unique Identifier. Guid are globally unique between table, databases, servers. Continue reading
EOMONTH Function is used to return last day of the month of the specified date. Continue reading
Choose function in SQL Server is used to get the item at the specified index from the list of available values. The index position starts with 1.
UnPivot is used to convert columns into rows. Continue reading
The Lead and Lag functions returns subsequent row for the Lead() while previous row for the Lag function. Continue reading
Rank() and DENSE_RANK() functions are used to return the RANK starting from 1 based on the ordering clause. Continue reading
In order to check the blocked queries in SQL server, we can make use of DBCC OpenTran command which will result in details of the transaction which has blocked the queries. Continue reading