无详细内容 无 use adventureworksgo-- count all rows and size of table by sqlservercurry.comselecttablename = obj.name,totalrows = prt.rows,[spaceused(kb)] = sum(alloc.used_pages)*8from sys.objects objjoin sys.indexes idx on obj.object_id =
use adventureworksgo-- count all rows and size of table by sqlservercurry.comselecttablename = obj.name,totalrows = prt.rows,[spaceused(kb)] = sum(alloc.used_pages)*8from sys.objects objjoin sys.indexes idx on obj.object_id = idx.object_idjoin sys.partitions prt on obj.object_id = prt.object_idjoin sys.allocation_units alloc on alloc.container_id = prt.partition_idwhereobj.type = 'u' and idx.index_id in (0, 1)group by obj.name, prt.rowsorder by tablename