SQL SERVER查询数据库所有表的大小，按照记录数降序排列

select b.name,a.row_count from sys.dm_db_partition_stats a,
sys.objects b
where a.object_id=b.object_id
and a.index_id<=1
and b.type=’u’and a.row_count>8000
  order by  row_count  desc