sql server misc: Folks,

Do you know of any negative ramifiactions/issues that can result
from switching off statistics gathering on a SQL Server 2000 box?
My understanding of statistics gathering is that is is collected by
the system to make the system more intelligent and then it can run
faster apparently.
I would greatly appreciate any ideas/suggestions/comments/life
experiences that you may have or like to share on this one -
especially from a performance point-of-view.

Cheers,

In a word "Don't". Don't turn off auto create/update statistics. Ok you
could if you have previously defined every query that will run through your
system and manually update every statistic you have defined each time
significant changes have been made OR you have every query and have used so
many hints that the optimizer only has one plan to choose. Ok this is crazy
talk...

In a DW sometimes DBAs turn off update stats but not create because they
will update manually during the ETL cycle and there are not updates outside
of that. This is the only situation I can think of there it makes some
sense.

Danny

[quoted text, click to view]