Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 3074 | Views in the last 30 days: 9
 
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
indexing    
table space    
 
Contribute