How to determine Free Space in data file?

Question

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

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

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

Try DBCC CHECKALLOC ('<database_name>').

This gives details about every table in the database but does give the number of used pages and the number of reserved pages.

Jeremy

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 2

Alternatively you could use:

sp_spaceused

If you don't specify a table name it reports the space used by the database. You might need to run

sp_spaceused @updateusage = 'true'

to make sure it gives the correct answer.

Jeremy

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

Try this:

DBCC SHOWFILESTATS WITH TABLERESULTS

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)