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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts