Posted on 2007-04-08
On maintenance plans i just increased the optimization
update statistics used by optimizer to 40 every night.
I was about to turn it off on the database and got
auto create statistics and auto update statistics
Got confused which one to turn off.
Our system is extremely busy used all day long with many
Which one do i turn off.....during the day.
If i turn if off i want to make sure that i do it at night
with a script ....which script would this be
dbcc updatestatistics ('dbname')