High LCK_M_SCH_M waits
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
Out-of-band query compile hotfix for SQL Server 2014
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...
Making SQL Server metadata queries easier with these new Views
Tip : Making SQL Server metadata queries easier with these new Views
Pagination with OFFSET / FETCH : A better way
I show how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.
Bad habits : Focusing only on disk space when choosing keys
I examine various impacts on SQL Server – not just disk space – when choosing a GUID as a clustering key.