CHECKDB found 39 consistency errors and said repair_allow_data_loss is the Minimum Repair Level, but the reader could not finish the repair. Here is my reply.
SQL SERVER – Ghost Cleanup Getting Hung and Blocking Checkpoint Process. What’s Wrong?
At a client, ghost cleanup was hung and blocking the checkpoint on a user database, with buffer latch timeouts in the ERRORLOG. Here is what I found.
SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT
A SharePoint check-in failed with Msg 8115, Arithmetic Overflow Error converting IDENTITY to data type INT. How I found the table with Profiler and fixed it.
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files
Shrinking TempDB kept failing: DBCC SHRINKFILE said the page could not be moved because it is a work table page. Here is the workaround that helped.
DMV to Replace DBCC INPUTBUFFER Command – Interview Question of the Week #100
Is there a DMV to replace the DBCC INPUTBUFFER command? An interview question that caught me off guard, answered with sys.dm_exec_input_buffer.
SQL SERVER 2016 – DBCC Command Enhancement with MAXDOP
SQL Server 2016 lets you set MAXDOP on DBCC checks like CHECKDB. Here is how this DBCC Command enhancement works and how to use it.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.