Table Size, row size

Question

Table Size, row size

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jay Bee-249994 SSCrazy Points: 2393 More actions · Answer 1

I've just found out, SP_SPACEUSED, without any tablenames, yields the total data size and the available space within a database.

I've just discovered 50Gb of space I didn't know about before, which is good news for me...but what YOU want to know is the flipside of free space, ie data size, and it will tell you this.

JB

Sergiy SSC Guru Points: 110209 More actions · Answer 2

Just make sure you've run DBCC UPDATEUSAGE (0) prior to SP_SPACEUSED, otherwise results returned may be incorrect.

_____________
Code for TallyGenerator

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 3

I think sp_spaceused with the table names, then extimating total size of deletion will be the most accurate way. That will include the index space that is being saved also. When you are done, I would suggest reindexing those tables to organize the indexes.

Thanks

Tom