Without locks how can i update date in the table ? [Resolved]

Posted by Sriharim under Sql Server on 6/2/2015 | Points: 10 | Views : 1177 | Status : [Member] | Replies : 1
In order table i have approximately 1 million records, Without locks how can i update date in the table ?

Mark as Answer if its helpful to you
---
Srihari



Responses

Posted by: Bandi on: 6/2/2015 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
you can update the table in batches...

you can find sample scenario to do batch-updates in SQL server
http://www.sqlusa.com/bestpractices2005/hugeupdate/
http://www.codeproject.com/Articles/12802/Batch-Update-on-a-very-huge-table
http://www.sqlservercurry.com/2011/02/fastest-way-to-update-rows-in-large.html

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response