Jack Corbett (1/5/2010)

---

I'd do explicit transactions and commit then you should be all set with the an error only rolling back the current transactions. You can do TRY CATCH...

Is it really possible to get the execution time dropped to nearly 10 seconds from 1 hour after running updates in batches?

Thats what i am getting and i am not...

Lowell, based on your example code, i have written my query below after removing case statements and making it simple to understand and clarify the logics:

SET ROWCOUNT 500000 --only fiddle...

Is it just because i don't end up updating same records again and again?

Lowell, as the destination column is a new column added...

Before answering to your comments, i'll like to tell more about what i am doing. I am migrating data with transformations on the staging database and then move the data...

gk-411903 (12/13/2009)

---

Hi

I am planning to set up replication between source and dest db's. But in case some mismatch arises i need to have a script which will compare the Destination...

Even i thought on the same lines after doing my research but i was not confident. Thats why i asked Masters for their suggestion. Thanks Steve for your feedback.

Like your response Nigel. What a way to tell the person to initiate and try to learn yourself. 😛

Also i was asked about clustering if you have 5 nodes where one is passive and rest are active and you are planing to add more nodes then what would...

depending on load on the production server you can use any option from high availability:-

replication

logshipping

mirroring

But you may have to factor in the pros and cons of each of the method...

I don't think this will solve the problem. If...

did secondary server changed to Standby mode?

This option of servername will only...

You are right Elliott, any single database more than 50 TB is of interest to me as well. I haven't heard of this much big single database (500K TB) in...