Post reply

Possible Corrupted Index - Strange Issue

  • August 15, 2013 at 5:53 pm

    #281180

    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

  • August 16, 2013 at 2:37 am

    #1642022

    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

  • August 20, 2013 at 11:34 pm

    #1643297

    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

  • September 19, 2013 at 5:25 am

    #1651451

    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