by the way... at least on windows 2003 file fragmentation is *not* really an
issue. thanks to the vssvc (shadowcopy) even files that are in use are being
defragmented. as far as i know, vssvc is also there in xp, but i can't
verify.
running a quick defrag on the db data partition defragmented all the
beforementioned heavily fragmented relation files without any problems,
eventhough the tables are actually being updated and in use while
defragmenting.
a regular defrag will be sufficient to keep the performance hit low - if
there is any noticable in first place, that is.
- thomas
