I've been scanning the net to try and find out how and when sql7 does the
auto update statistics. We're getting some blocking on our server and the
waitresource column in sysprocesses is showing as syscolumns. The only thing
I can think of is that an insert/update or delete has been performed and sql
server is updating the indexes or statistics for the given table. Would this
make any sense or am I way off base?
Does auto update statistics wait until there is a quite period before
updating the statistics?