The Secret Diary of Han, Aged 0x29

twitter.com/h4n

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