I describe a scenario where Common Criteria compliance was deemed the cause of high LCK_M_SCH_M waits for multiple customers.

I show some views I use to make metadata queries simpler.

I show how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.

I examine various impacts on SQL Server – not just disk space – when choosing a GUID as a clustering key.