Browse by Tags

Tagged Content List
  • Blog Post: TechEd session video available...

    The session I gave at TechEd this year on 'Secrets of Fast Detection and Recovery from Database Corruptions' was videotaped as part of the Its Showtime! TechEd program. The video is now available to watch at http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=549 . This is the same session...
  • Blog Post: How long does *your* CHECKDB take?

    Following on from my post a couple of weeks ago ( https://blogs.msdn.com/sqlserverstorageengine/archive/2007/01/24/how-long-will-checkdb-take-to-run.aspx ), I'm very interested to know how long it takes for your CHECKDBs to run, so I can get an idea of the distribution of run-times on various kinds of...
  • Blog Post: CHECKDB (Part 8): Can repair fix everything?

    I was teaching at a Microsoft-internal class last week and there was a discussion on what corruptions can't be repaired using DBCC. At the same time, several threads popped up on forums and newsgroups with people hitting some of this unrepairable corruptions so I thought that would make a good topic...
  • Blog Post: CHECKDB (Part 7): How long will CHECKDB take to run?

    This is a question I see every so often and it cropped up again this morning so I'll use it as the subject for this week's blog post. There are several ways I could answer this: the unhelpful answer - I've got no idea. the almost-helpful answer - how long did it take to run last time and...
  • Blog Post: CHECKDB (Part 6): Consistency checking options for a VLDB

    (Yippee - just finished my certification dives and got my PADI Open Water certification - just in time for our dive trip to Indonesia in December :-) This is a question that comes up a lot - in fact 3 times this week already - most recently during a guest lecture I did on DBCC for one of Kimberly...
  • Blog Post: CHECKDB (Part 5): What does CHECKDB really do? (part 4 of 4)

    (Another airport, another blog post - I really must make an effort to come up with more original banter - I'm sure I've used that line before. TechEd Guangzhou has finished and I'm on the way to Beijing for TechEd #3. Checking in and getting through security were challenging to say the least this morning...
  • Blog Post: CHECKDB (Part 4): What does CHECKDB really do? (part 3 of 4)

    (OK - I was wrong about the posting frequency - events overtook me and I got bogged down preparing for these TechEds. China is an amazing place and I wish I had more time to soak up some of its culture while I'm here but with the TechEds being so close together there's little time for anything except...
  • Blog Post: CHECKDB (Part 3): What does CHECKDB really do? (2 of 4)

    In the previous post of this series, I covered the system table checks that have to be done before anything else can be checked by CHECKDB. Now that I've described pages , extents , IAM chains/allocation units and the major allocation bitmaps , in this post I'll cover the allocation checks. 1. Primitive...
  • Blog Post: CHECKDB (Part 2): What does CHECKDB really do? (1 of 4)

    Hmmm - I sat for 5 minutes thinking of something amusing to say to start this one off and nothing came to mind, so I'm afraid this will be a humor-free post. Maybe I'm jet-lagged from being on the East coast all last week. As with all things related to DBCC, this topic has its share of misinformation...
  • Blog Post: CHECKDB (Part 1): How does CHECKDB get a consistent view of the database?

    As you can guess from the title, I'm planning a long series over the summer to go into the guts of how CHECKDB works (both the consistency checks part and the repair part). And as you can guess from 'CHECKDB', I'm already bored with putting DBCC in front of it all the time and changing the font to Courier...
Page 1 of 1 (10 items)