Post reply

Removing database holes

  • November 15, 2007 at 8:12 am

    #73862

    Guys,

    Is there a way to compact the database? We do many inserts and deletes, where #inserts approximately equals #deletes,and yet the database size constantly keeps growing. I feel like there are a lot of holes in the database file, which, if gotten rid of, should decrease the overall database file size.

    I know that I can shrink the database file(s), but not sure if it is same as compacting it.

    Any ideas?

    Thanks a lot

  • November 15, 2007 at 10:42 pm

    #751711

    Hi

    there is nothing like compacting a db in that sense of the word. U can do frequent log backups to keep the log file size in check. Also you can move old data not used to another database.

    "Keep Trying"

  • November 16, 2007 at 3:07 pm

    #751995

    I actually found out that this can be done by using: DBCC DBREINDEX

    Thanks

  • November 26, 2007 at 10:53 am

    #754156

    That can help with internal fragmentation and provide some speed gains.

    However, don't shrink the db. That undoes what you do with reindexing.

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

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