Re: Dropping a uniwue clustered index HELP

From: pdxJaxon (GregoryAJackson_at_Hotmail.com)
Date: 03/30/05

Next message: len: "Remote server Error..."
Previous message: Jacco Schalkwijk: "Re: Why Windows Authentication?"
In reply to: marcmc: "Dropping a uniwue clustered index HELP"
Next in thread: Hari Prasad: "Re: Dropping a uniwue clustered index HELP"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 30 Mar 2005 09:37:20 -0800

Dropping the index reorganizes all data in table. If you have lots of data,
expect a wait (this is normal)

Further, the Table is Exclusively locked during this time frame so not to be
done during production hours.

Greg Jackson
PDX, Oregon

Next message: len: "Remote server Error..."
Previous message: Jacco Schalkwijk: "Re: Why Windows Authentication?"
In reply to: marcmc: "Dropping a uniwue clustered index HELP"
Next in thread: Hari Prasad: "Re: Dropping a uniwue clustered index HELP"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Building out a CD Collection: Segovia
... production versions can you point me in that direction? ... quest, may I ask? ... You might also consider dropping $27 or so, plus S/H, on the DVD of ... performance and interview material worth viewing and listening to. ...
(rec.music.classical.guitar)
Re: Rush Limbaughtomy and Sean Insanity shift blame for Repug recessions
... Production began declining in ... Stock prices were dropping before that.http://en.wikipedia.org/wiki/Dot-com_bubble ... years in office never gave him enough time to straighten it out, huh? ...
(soc.retirement)
Re: Porsche Cayenne S Mini-review.
... minute seems to be that we passed peak oil about 2-4 years ago, so production capacity is dropping ... Production isn't dropping. ... All the new oil and gas to be found is from expensive sources. ...
(uk.rec.cars.modifications)