Post reply

DBCC CHECKDB Limits II

  • July 13, 2026 at 12:00 am

    #4868801

    Comments posted to this topic are about the item DBCC CHECKDB Limits II

  • July 14, 2026 at 12:10 am

    #4892483

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • July 27, 2026 at 1:39 pm

    #4907651

    Disabling an index is the same as dropping it, except that it's meta data are preserved, so that you can rebuild it later without the need to know the exact definition including filter, column order, fill factor, MS_Description, compression etc..

    But the data pages of the index will be deleted (or better be marked as free / unused), as soon you execute the ALTER INDEX ... DISABLE command and DBCC CHECKDB does not check unused space in the database.

    When you execute the REBUILD the SQL Server will read the whole clustered index / heap table (or in some rare cases another covering nonclustered index) and recreates the index data pages / index tree from scratch.

    God is real, unless declared integer.

  • July 27, 2026 at 3:39 pm

    #4907725

    Yep, the index data is gone, so no checking.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply