Paul Randal (3/12/2010)
We're talking about table corruption here. The real crux of the matter was 'rebuilding indexes' being offered as a solution without demonstrating understanding of the problem. All caps and asterisks are called for when someone continues to argue something that is wrong.
I didn't argue , nor did I shout out anyones competence or not ...
You asked a question, so I provide an answer for my grounds of providing the info.
Rebuilding a corrupt nonclustered index might be able to remove the corruption on occasion, but that doesn't fix the cause of the corruption.
there is still missing input ... the actual dbcc output to confirm the diagnose and work on the solution ...
Just trying to help isn't good enough when helping someone deal with corruption in production - giving the correct solution is.
I'm not pretending to be ms pss.
I'm not trying to sound arrogant or conceited, but an admission of not knowing what the corruption problem is but still offering a solution isn't helpful in my book. Nor is arguing the solution with the person who wrote the code that generated the error being discussed. I hate saying that.
Whoa ... that's clear .... some people actually read signatures.
BCP out is a good idea but wouldn't work as the server wouldn't be able to process the corrupt value.
Now that's a positive input .... I applaud that !
I've alreaddy stated my gratitude for your numerous contributions at SSC on previous - not so negative - encounters.
Whilest I still respect that fact you help out, it's a shame you fall back to a negative bully attitude
I'm just a mortal dba, I didn't write the code, I just suffer it on a daily basis.
I really hope OP is suffering the actual error, or (s)he for sure will not publish his actual error info, being a fairly new forum member and risking to be flamed or being thrown whatever at her/him.
Robert Davis (3/12/2010)
I could really go for some popcorn while I watch the show.
Thanks to everyone trying to alter the tone of this thread.
Enjoy the weekend.