SELECT o.name as tablename,s.* FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) s,sys.objects o where o.object_id =s.object_id order by avg_fragment_size_in_pages desc