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

rowversion vs Change Tracking Expand / Collapse
Posted Monday, August 20, 2012 1:55 PM


Group: General Forum Members
Last Login: Sunday, August 28, 2016 9:42 PM
Points: 18, Visits: 672
I'm trying to determine whether I should use the rowversion column to find data changes for an ETL process that will push updates to a cube. According to Erland Sommarskog, in the post linked to below, "if there are plenty of concurrent updates, it can become very difficult to avoid that you miss changes" using rowversion. Unfortunately I can't find more information about that and while I trust Erland, it would be easier to use rowversion if we could.
Post #1347458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse