Viewing 15 posts - 5,446 through 5,460 (of 8,416 total)
Thanks for the clarifications. It helps.
So, would one answer be to identify the corrupt rows via DBCC PAGE, export the good (and accessible) data only, and re-create the duff...
March 12, 2010 at 7:31 pm
That's good to hear, even if it surprises me!
March 12, 2010 at 7:07 pm
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.
Jason...CTRL...
March 12, 2010 at 7:04 pm
Lynn Pettis (3/12/2010)
Paul White (3/12/2010)
Eralper (3/12/2010)
I'm sorry you thought that to be spam. I posted my experience with that tool only. That is not a spam.
It looked like spam...
March 12, 2010 at 6:55 pm
Abhijit More (3/12/2010)
Key can have mutiple Ref and Ref can be linked with multiple Key.
So why didn't you say it is a bridge table in your original question?
A simple example...
March 12, 2010 at 6:53 pm
Steve Jones - Editor (3/12/2010)
I have a simple one, but if anyone wants to suggest one, feel free.
"Which system tool would you use to determine the answer to this question?...
March 12, 2010 at 6:49 pm
Paul Randal (3/12/2010)
Rebuilding indexes is **NEVER** a solution for fixing corruption.
:blink: :unsure:
Unless the a corruption is confined to the non-clustered index, right?
Not the case here - for sure - but...
March 12, 2010 at 6:43 pm
Alvin Ramard (3/12/2010)
Lynn Pettis (3/12/2010)
I'm waiting for the Average DBA Competition. I'll nominate myself for that one.
I'm waiting for the I'm Not a DBA Competition. I'll nominate myself...
March 12, 2010 at 6:30 pm
GilaMonster (3/12/2010)
March 12, 2010 at 6:28 pm
icampbell (3/12/2010)
Oh! How i miss the ease of doing PL/SQL
Swings and roundabouts. Let's not go down that road eh?
BTW Excel can prompt for input :laugh:
March 12, 2010 at 9:23 am
RBarryYoung (3/12/2010)
Paul White (3/12/2010)
GilaMonster (3/12/2010)
and how fast time flies.
Tell me about it. How can summer be over already? 🙁
Freak storm over here this afternoon - roofs ripped off, trees...
March 12, 2010 at 9:22 am
Elliott W (3/12/2010)
Great, I'll add you to the list. Thanks. I can take the abuse.
Quoted so you can't edit that statement away. My future lawyers might need...
March 12, 2010 at 9:21 am
Viewing 15 posts - 5,446 through 5,460 (of 8,416 total)