Get Table Size in SQL Server | Query to Get Table Size in SQL Server 2008

Here I will explain how to get table size in SQL server or query to get table size in SQL server 2008.

Description:

In previous articles I explained Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get table size in SQL server.

To get table size in SQL server we need to write the query like as shown below

Syntax

SP_SPACEUSED 'YOUR TABLE NAME'

Example

SP_SPACEUSED 'USERDETAILS'

Once we run above query we will get output like as shown below

Demo