Week 6 Extra Clue

Jump back to Database Corruption Challenge 6 (DBCC).

SPOILER ALERT

Stop

reading

now

if

you

don’t

need

the

extra

clue.

Page down if you need the clue….

SPOILER ALERT

Stop

reading

now

if

you

don’t

need

the

extra

clue.

Page down if you need the clue….

 

 

---

There have been a few request this week for an extra clue. So here are two clues… Posted at 1:30pm (Pacific Time) on 5/25/2015.

• Sometimes when there is more than a single corruption in a database, fixing the first corruption prevents you from being able to see where the other corruption is later.
• There is a big difference in an index if you drop it and recreate it compared to if you just do an ALTER INDEX …  REBUILD.  The rebuild keeps the same data in the index if it is can, and the drop and recreate, rebuilds the index from the table.

I hope this helps…

Jump back to Database Corruption Challenge 6 (DBCC).

Getting Help from Steve and the Team

Contact us for your Free 30 minute consultation OR
schedule your appointment now.