SQL queries the number of record bars for all tables in the database, as well as the amount of disk space consumed.

1 SELECT2TableName =Obj.name,3Totalrows =Prt.rows,4[SpaceUsed (KB)] = SUM (alloc.used_pages) *85 From sys.objects obj6JOIN sys.indexes idx on obj.object_id =idx.object_id7JOIN sys.partitions prt on obj.object_id =prt.object_id8JOIN sys.allocation_units alloc on alloc.container_id =prt.partition_id9 WHERETenObj.type ='U'and idx.index_id in (0,1) One GROUP by Obj.name, Prt.rows AORDER by Totalrows DESC

SQL queries the number of record bars for all tables in the database, as well as the amount of disk space consumed.