Does updating statistics cause tables to be inaccessible? In other words, can you run this procedure without downtime?
Specifically for SQL Server 2005
+1
A:
No, and Yes.
sp_updatestats can be run against a live database without downtime.
ahockley
2008-11-19 21:45:26
What's the "Yes" part of your answer?
Rich
2008-11-19 21:46:50
The question asked if it causes tables to be inaccessible, to which I said No. The question then asked "in other words, can you run this without downtime", to which I said Yes.
ahockley
2008-11-19 22:00:59
+1
A:
In SQL Server 2000, you can run this procedure without causing downtime. I doubt that has changed in later versions.
RoadWarrior
2008-11-19 21:45:55