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 » Indexes » fragmentation   (RSS)
  • Geek City: Fragmentation Internals

    Yet another fragmentation post, to answer a question asked in response to a previous answer.... SQL_Girl is still confused about DETAILED vs LIMITED, and I don't blame her. She reported that the BOL says:  ''The nonleaf levels of indexes are only processed when mode = DETAILED. ''  But I had said: ''The second misunderstanding involves ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 6, 2008
  • 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
  Privacy Statement