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.
is pronounced ree-bar and is a Modenism for R
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs