Table Size in SQL Server | Find Rows and Disk space Usage

Wednesday, November 12th, 2008

There are two ways to get the table size Run the stored procedure exec sp_spaceused "Sales.ContactCreditCard" Now what if you needed to get a list of Top 20 Tables by number of rows or disk space? Use the following query SELECT t.schema_name+ ' - '+ t.table_name as schema_table , t.index_name , sum(t.used) as used_in_kb , sum(t.reserved) as reserved_in_kb , ...