From: "Antti Kurenniemi" 

"/m"  wrote in message
news:r86el2dfl5qiqd9ob6dbvt6ncts7rlluum{at}4ax.com...
>>> Don't compact then. It's really got piss all to do with anything but
>>> disk
>>> space which should be cheap enough unless you run terabyte size
>>databases...
>>
>>Actually no, it makes a huge speed difference along with the space
>>difference.
>
>
> That's what I've seen.   My friend's company uses SQL Server and they
> found they have to "compact" each night to keep the performance where
> they need it to be.

I would be investigating such database quite closely - it should not be
needed, and I suspect that something is not done properly. Don't really
know about old SQL server versions, but 2000 and later definately do not
neet compacting that often.


Antti Kurenniemi

--- BBBS/NT v4.01 Flag-5