Comments (17)

  1. Thanks to Paul Randal for pointing out my math error. The PFS repeats every 64 MB, not every 1/2 GB. Corrected in this post and in the tempdb contention post.

  2. Hi Davis, thanks for sharing your tech, very very very nice post. please keep up the good work. I’m waitting for your next post, yeah !

  3. […] Continue reading here: Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in … […]

  4. […] Recovery series. I’ve previously discussed handling corruption for nonclustered indexes and allocation pages. Today, I’m going to talk about a specific corruption that is very simple to fix; however, it […]

  5. Hi Davis …

    Great post .. Thanks for sharing ..

    Even i had trouble finding out … after how many pages does PFS reappears
    1/2 GB or 64 MB …

    Thanks Again

    1. Thanks Gurpreet. I did know the right value up front because I learned it from Paul Randal to start with. Just had a brain lapse for a minute when writing it. :)

  6. […]… […]

Leave a Reply

Your email address will not be published. Required fields are marked *