In this blog, we are 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:
- Rows- Number of rows existing in
the table,
- Reserved- Total amount of reserved
space for Table,
- Unused- Total amount of space
reserved for table but not yet used,
- 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: