Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Update query - need suggestion Expand / Collapse
Posted Friday, April 9, 2010 10:02 PM



Group: General Forum Members
Last Login: Yesterday @ 10:52 PM
Points: 42,083, Visits: 39,479
Baskar B.V (4/9/2010)
Forgot to mention in the previous post.

The total records which would get updated would be around 10 million records.

My recommendation is that you split that up into batches of about 2 million rows or less. Every system has a "tipping point" depending on a whole bunch of unpredictable factors. Depending on where the tipping point of your system is, it may only take 6-12 seconds to update 2 million rows but may take 10 hours to update 10 million rows in a single query.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #900959
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse