How To Find The Physical Size Of SQL Server Tables And Indexes
Read Time:44 Sec
Inspired by Shannon’s post (give me the size of data and indexes for a file in an oracle database please), I found a SQL statement that finds the size of each table and index in a SQL Server database. I also found that there are a ton of different ways to get this information. Below is the method that I is most beneficial to me:
EXEC sp_spaceused GO DECLARE @spaceUsed TABLE ( name varchar(255), rows int, reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(50)) INSERT INTO @spaceUsed EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'" SELECT name, rows, left(reserved,len(reserved)-3) as [reserved (KB)], left(data,len(data)-3) as [data (KB)], left(index_size,len(index_size)-3) as [index_size (KB)], left(unused,len(unused)-3) as [unused (KB)] FROM @spaceUsed order by rows desc
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating