I'm new to MSDE but we're having performance degredation on some of our tables, even though rows are being purged on a regular basis (as part of our Archive process).
My question is, when rows are purged, is the space automatically compacted or is that space left residing on the database, marked as deleted ?
Is there a way of compacting an MSDE database, or is it not necessary ?
Obliged for any replies .
Cheers, Dave (TNT)