Monday, June 27, 2011

Count Rows in Tables and its Size

Run the below query to count Rows in Tables and its size.

TableName =,
TotalRows = prt.rows,
[SpaceUsed(KB)] = SUM(alloc.used_pages)*8
FROM sys.objects obj
JOIN sys.indexes idx on obj.object_id = idx.object_id
JOIN sys.partitions prt on obj.object_id = prt.object_id
JOIN sys.allocation_units alloc on alloc.container_id = prt.partition_id
obj.type = 'U' AND idx.index_id IN (0, 1)
GROUP BY, prt.rows
ORDER BY TableName

No comments:

Post a Comment