Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Update StatisticsHello, SQL 2000, SP4.... Does anyone know if Update statistics <tablename> with fullscan will cause blocking/locking ? Can users insert/update/query the table while the above i s running ? Thanks , Ranga
Post Follow-up to this message
Re: Update StatisticsIt does a scan using read uncommitted so there will be minimal locking if any. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Ranga" <Ranga@discussions.microsoft.com> wrote in message news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso ft.com... > Hello, > > SQL 2000, SP4.... > > Does anyone know if Update statistics <tablename> with fullscan will cause > blocking/locking ? Can users insert/update/query the table while the above > is > running ? > > Thanks , > Ranga > >
Post Follow-up to this message Re: Update StatisticsUPDATE STATISTICS should only take schema modification locks. That will prevent dropping the table/index during a stats update. Regular statements should not block while statistics are being updated. Regards, Leo "Ranga" <Ranga@discussions.microsoft.com> wrote in message news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso ft.com... > Hello, > > SQL 2000, SP4.... > > Does anyone know if Update statistics <tablename> with fullscan will cause > blocking/locking ? Can users insert/update/query the table while the above > is > running ? > > Thanks , > Ranga > >
Post Follow-up to this message Re: Update StatisticsThank you very much for your replies. "Leo Giakoumakis [MS]" wrote: > UPDATE STATISTICS should only take schema modification locks. That will > prevent dropping the table/index during a stats update. > > Regular statements should not block while statistics are being updated. > > Regards, > > Leo > > > "Ranga" <Ranga@discussions.microsoft.com> wrote in message > news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso ft.com... > > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
