InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 09:11:10 GMT20http://www.sqlservercentral.com/Forums/Topic1374222-392-1.aspxThanks very much for your help. Thats exactly what I needed.Thu, 18 Oct 2012 03:56:08 GMTggjjbb1983http://www.sqlservercentral.com/Forums/Topic1374222-392-1.aspxYup, it can be due to the snapshot.[url]http://www.sqlservercentral.com/articles/Performance+Tuning/64080/[/url]Thu, 18 Oct 2012 03:40:39 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1374222-392-1.aspxHi,I am running an update to a large number of rows on a table in a database which has a snapshot. The update is quite slow, so I was just wondering if having a snaphot in place will slow down updates at all, as the original pages will need to be copied to the snapshot for each modification?It may just be due to the large amount of data; however I'd like to rule out the possibiltiy that the update is not being slowed down by the snaphot being in place.Thanks.Thu, 18 Oct 2012 03:34:44 GMTggjjbb1983