From: mike 

On Sun, 12 Nov 2006 22:05:28 +0200, "Antti Kurenniemi"
 wrote:

>"/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.

Nightly is what they need to do.

 /m

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