> (I should have thought a single file DB would be MORE liable to
> fragmentation, BTW).
AFAIK what mssql does against fragmentation is: it preallocates its
tablespace in chunks of several mb/gb and then starts filling the free
allocated space until it has to reallocate more. the fragmentation for such
a single file (actually in most times 2 files for mssql) is practically
ignorable.
- thomas