THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » storage » Fragmentation   (RSS)
  • Performance impact: Logical scan fragmentation -- 100% may not be as bad as 85%

    In this previous post I asked whether 100% logical scan fragmentation is always worse than 85% local scan fragmentation for table/index scans. (To be precise, I was talking about a B-tree table, i.e. a table with a clustered index).   The answer is no. 100% logical scan fragmentation is not always worse than 85% logical scan fragmentation ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on June 22, 2009
  • 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
Privacy Statement