#checkdb

New #Blog post and #TSQL script: Incremental Integrity Check for Large Databases #Microsoft #SQLServer #MadeiraData

Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super cool tools like Ola Hallengren’s maintenance solution. To address this challenge, I developed a TSQL script for performing incremental integrity checks, which significantly optimizes the process and reduces its impact on the server. Continue…

What to Do When DBCC CHECKDB Reports Corruption

Database corruption is something that you hope you never have to deal with, but is eventually going to happen to everyone if you deal with databases long enough. In this article from Brent Ozar, we get his take on the steps to resolve the issue, as well as when and how to communicate the status of the issue to your team.

Query the msdb.dbo.suspect_pages table.

If it’s just one database, send an…