• You might want try running that dmv with the 'LIMITED' option:

    FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, 'LIMITED')

    as it will have better performance, specially if it is a big table.

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]