Why is the database still occupied to the same extent after extensive data archiving?
If data is deleted from the database, the blocks of the affected objects are cleared, but the amount of space the affected objects occupy is not reduced. To make the space that is no longer occupied available for general use again, you must reorganize the objects concerned. See Notes 572060 and 541538 for more information. Also refer to Note 821687, which contains detailed information about space occupancy and fragmentation.
Related Questions
- How does OR mapping deal with cases where data is not fully committed to the database? How would rollback take place on complex queries?
- I want to use Merge Replication to synchronise data to my SQL Server CE database. Are there any how-to whitepapers available?
- How does my data on the handheld unit get to the Trax database?
