How to Get the Table Size in SQL server 2008

In this blog, I am going to show how we can get the actual data table size in SQL Server-2008 in a very easy way.

To get the table size in SQL Server 2008, we need to use a system stored procedure named “sp_spaceused”

If we pass Table Name as an argument, it gives the disk space used by the table and some other information like:

1. Rows- Number of rows existing in the table,
2. Reserved- Total amount of reserved space for Table,
3. Unused- Total amount of space reserved for table but not yet used,
4. Index_Size- Total amount of space used by indexes in Table.

Example

For the ADDRESS table in our database, if we run

sp_spaceused 'TADDRS'

It will give following result: