Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
What is a clean buffer in DBCC DROPCLEANBUFFERS? No one had asked me this in 20 years, so here is the answer in the simplest words I could find.
SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL
A weekly DBCC CHECKDB job was stopped by a terminator job, but its SPID stayed, waiting on PREEMPTIVE_OS_DEVICEIOCONTROL. Here are ways to handle that situation.
SQL SERVER – New Way to Use DBCC Page in SQL Server 2019
SQL Server 2019 brings a new function that partly replaces DBCC PAGE. I compare the old and the new way to read page information with a small demo.
SQL SERVER – Monitor Estimated Completion Times for Backup, Restore and DBCC Commands
A handy script from Dominic Wirth to monitor estimated completion times for backup, restore and DBCC commands, so you are not left guessing.
What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188
What part of the SQLDump suggest database corruption? A reader asked, and I show the DbccResults tag in the SQLDump text file that confirms it.
SQL SERVER – Why Suddenly DBCC CHECKDB Running Very Slow?
Why is DBCC CHECKDB running very slow all of a sudden? A client’s check went from 8 minutes to over 24, so I looked into what changed.