I describe a scenario where Common Criteria compliance was deemed the cause of high LCK_M_SCH_M waits for multiple customers.
Monthly Archive: January 2015
Last week, Microsoft released an out-of-band hotfix to resolve an issue surrounding excessive RESOURCE_SEMAPHORE_QUERY_COMPILE waits. If you are experiencing this issue, or if you are diligent about applying the most recent hotfixes, you should...
Tip : Making SQL Server metadata queries easier with these new Views
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.