From: hvandenberg@xs4all.nl   
      
   Henk van den Berg schreef op 10-05-2011 12:51:   
   > SGoncalves schreef op 10-05-2011 12:44:   
   >> On May 9, 10:59 pm, Erland Sommarskog wrote:   
   >>> SGoncalves (goncalves.serg...@gmail.com) writes:   
   >>>> I've been checking fragmentation levels in the production database,   
   >>>> and I've encountered some curious (or not).   
   >>>> When I select the sys.dm_db_index_physical_stats I have many indexes   
   >>>> with 99% avg_fragmentation_in_percent, but when I go through the GUI   
   >>>> into the same indexes and check the fragmentation it show 0,01%.   
   >>>   
   >>> Not sure what you see, but beware that if you run with DETAILED mode,   
   >>> you will also get the intermediate levels in the index, and they are   
   >>> often   
   >>> quite fragmented. On the other hand that is no cause for alarm.   
   >>>   
   >>> --   
   >>> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se   
   >>>   
   >>> Links for SQL Server Books Online:   
   >>> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   >>> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   >>   
   >> How can I check the DETAILED mode?   
   >>   
   >> Thanks in advance.   
   >   
   > http://msdn.microsoft.com/en-us/library/ms188917.aspx   
   Oops, inadvertently hit ctrl-enter   
      
   I was gonna add:   
      
   mode | NULL | DEFAULT   
      
        Is the name of the mode. mode specifies the scan level that is used   
   to obtain statistics. mode is sysname. Valid inputs are DEFAULT, NULL,   
   LIMITED, SAMPLED, or DETAILED. The default (NULL) is LIMITED.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)