The Secret Diary of Han, Aged 0x29

Archive for August 2006

Database shrink and space used

When investigating SQL server size problems you can use the following commands from within query analyzer

  • exec sp_spaceused tablename
  • dbcc shrinkdatabase( databasename )

for example:

exec sp_spaceused AlertFilter

dbcc shrinkdatabase(onyx)


Written by Han

August 31, 2006 at 11:08

Posted in Uncategorized