MS SQL Server Queries

An assortment of Microsoft SQL Server Queries that I have found useful at some point.
This repo is meant for my reference, but if you've stumbled accross it feel free to have a poke around.
Where I know the original author, or where I originally got a query from, I will include a name or link in a comment at the top of the file, although the query may have been modified (hopefully improved) from the original.