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: 1792 | Views in the last 30 days: 16
 
Related Articles
FORUM

index space inside data file

index space inside data file

FORUM

Index Types and Primary Keys versus Space Used

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

FORUM

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...

FORUM

Free space

Free space

FORUM

creating clustered index, space utilization

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

Tags
index space    
table space    
 
Contribute

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
Editor, SQLServerCentral.com

Already a member? Jump in:

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