Do a rolling upgrade.

1. Isolate primary node from passive so it can't failover

2. Apply service pack to secondary/passive node

3. Activate passive node back on cluster for failover

4. manually failover primary...

better than set rowcount use top option in the loop. It's even faaster.

wrote this before Sybase had the top option .. sql server always had it.

begin tran

delete top 500...

Try Qlikview at qlikview.com .. for demos http://demo.qlikview.com/?ga-link=promo ..

My first PC was an IBM/XT circa 198x. It had a 10MB (that's MB, not a type) ahrd drive, with 256 bytes of memory (the mem upgrade was on a...

We are migrating to a 2-node active-passive cluster on Win 2008/R2 with SQL Server 2008 Enterprise, with 64gb of RAM on HX5 blades. The use is data pump for HIPAA...

The reason range deletes are slow is single log writes, and lots of contect switching. The below example does 1 log commit for 500 rows, and two context switches (runq...

declare @rows int

select @rows = 1

set rowcount 500 -- domain Udt commits

begin tran

while @rows > 0

begin

end