Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:30 AM
Points: 18, Visits: 560
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.

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/7f1cea96-7cf4-4feb-97f4-c15095adf449
Post #1347458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse