Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Possible Corrupted Index - Strange Issue Expand / Collapse
Author
Message
Posted Thursday, August 15, 2013 5:53 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:03 PM
Points: 480, Visits: 469
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



Post #1484950
Posted Friday, August 16, 2013 2:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 40,208, Visits: 36,617
Try doing an update stats for each stats object on that table, one by one.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1485030
Posted Tuesday, August 20, 2013 11:34 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:03 PM
Points: 480, Visits: 469
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



Post #1486521
Posted Thursday, September 19, 2013 5:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970
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
Post #1496321
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse