Using Dynamic SQL and Subqueries in MS SQL: A Deep Dive

How to Get Random Rows Without Duplicates in SQL Server Using Advanced Window Functions

How to Use SQL LEAD and LAG Window Functions to Solve Gaps-and-Islands Problems