Limiting Number of Rows using ROWS OFFSET in T-SQL

Merging Results from Multiple Columns into One: A SQL Server 2012 Solution Using UNION ALL and COALESCE

How to Handle Duplicate Data in SQL: Using Various Techniques for Clean Data Sets

Understanding Transaction Isolation Levels and Nested Transactions in SQL Server