C
ChUIMonster
Guest
Rich has said that you should run UPDATE STATISTICS when 20% of your data has changed. He then asks, rhetorically, how you can know that 20% of your data has changed... (I suppose you could keep track of bi cluster closed?) Personally, I often suggest weekly because: 1) It does no harm. 2) Most people have a slow time at least once a week when it is convenient to do so. 3) It is easy to script and there are several other things that I like to do weekly (dbtool, truncate logs, run dbanalys). 4) Weekly routines are less likely to be forgotten than monthly or even more irregular tasks.
Continue reading...
Continue reading...