• anthony.green (2/18/2013)


    whats the output of this query in the DB in question?

    select

    *

    from

    sys.dm_db_index_physical_stats (DB_ID(),null,null,null,null)

    where

    page_count > 1000

    and

    index_type_desc <> 'heap'

    The output of the above query shows indexes. The maximum amount of fragmentation return by the above query is not more than 35, could you please tell me what does that mean?