How to Get the Table Size in SQL server 2008
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:
No comments:
Post a Comment