Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Total space used per table

By Louis Li,

I have received some comments on getting total space of table and all indexes, so I rewrote an old query to return total space used, space used by heap table or clustered index and space used by non-clustered indexes.

Instructions: Run this query, result ret is sorted by name. If you need result sorted by space, simply change order by clause.

Total article views: 3019 | Views in the last 30 days: 16
Related Articles

index space inside data file

index space inside data file


Index Types and Primary Keys versus Space Used

Compare Clustered, NonClustered and Primary/no Primary key indexes versus table space


Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan?

Is it possible to create nonclustered index on columns with space and ignore the space so that it do...


Free space

Free space


creating clustered index, space utilization

large table, several non-clustered indexes.....

table space    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones