Richard M. (4/23/2010)
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.
I was going to suggest that too, but I checked BOL and it says LIMITED is the defualt when NULL is specified, so it looks like that's already the case.