THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DMVs » fragmentation   (RSS)
  • Did You Know? Fragmentation, revisited....

      A couple of questions arrived regarding my earlier post about fragmentation on the system tables, and since the questions really don't have anything to do with system tables, I felt they deserved a new post. 1) Using the DETAILED option includes the non-zero index-levels as well (non-leaf pages).  According to many source, this ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 28, 2008
  • Geek City: Fragmentation on the System Tables

    It's my first post of the new year. I hope it's starting out well for all of you! New year, but sometimes the same old questions. I got another email asking about defragging the system tables. It seems to be in the Hit Parade of FAQs. First of all, WHY do you think you would need to defrag a system table? Fragmentation is only a problem when you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 17, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement