Monday, March 05, 2012
Whenever we are called in to fix a database that is misbehaving, we always head for the old standards of Compact and Repair, decompile and exporting all the objects into a brand new database. When the dust settles and the database looks way too big for the information that you percieve is inside the database, there is nothing you can do to find out what is taking up all the space. This page discusses how you can use the two recent save to text posts to work out the size of objects. There is also a link that discusses unnecessary indexes as they too can bloat a database a few percent.