Discussion in 'SQL Server 2008 General DBA Questions' started by vna_mhars, Feb 16, 2011.
Can I use the database while full scan in update statistics is running?
Welcome to the forums!.
I don't recommend to do that. Schedule a job in a windows time.
About your question: yes.
Welcome to the forums.
It depends on how frequently and how many tables & their rowcount are involved in this update statistics task.
By default there will be shared locks applied which update statistics is running.
Separate names with a comma.