Possible Corrupted Index - Strange Issue

  • Hi,

    I'm getting a Corrupted Index error message when running UPDATE STATS ... "Possible index corruption detected. Run DBCC CHECKDB."

    I've tracked down which table is causing the problem and have tried rebuilding all of the indexes on the table and everything rebuilds without any problems.

    I've run a CHECKDB on the database and again no errors are found.

    I've tried running the UPDATE STATS on each individual index in the table and it works fine, no errors.

    But if I run the UPDATE STATS for the whole table Eg ... "UPDATE STATISTICS [dbo].[tablename]" it still returns the "Possible index corruption detected. Run DBCC CHECKDB." error message.

    Any ideas?

    Cheers

  • Try doing an update stats for each stats object on that table, one by one.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (8/16/2013)


    Try doing an update stats for each stats object on that table, one by one.

    I managed to track down the issue, in the end it turned out to be bad data. There were 3 records in the table with invalid data in a float field, updating the 4 float fields on the 3 rows fixed the problem.

    Cheers

  • dougjjj (8/20/2013)


    I managed to track down the issue

    How did your figure it out ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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