Post reply

DBCC and disabled indexes

  • June 21, 2015 at 1:40 am

    #1806891

    Very good question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • June 22, 2015 at 12:14 am

    #1806932

    I thought so. Why else should you use CHECKDB if there is no warning on such a situation ?

    A little time ago here in the QOTD there were some questions about disabled clustered indexen.

    After disabling the PK clusterd/index it was even not possible to select on that table.

    So it had to be someting like that.

  • June 25, 2015 at 6:57 am

    #1808030

    Learned more about DBCC today.

Viewing 3 posts - 16 through 17 (of 17 total)

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