Row Versioning

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Row Versioning

Row Versioning

Rate Topic

Display Mode

Topic Options

Author

Message

ratheesh4sql

Posted Tuesday, February 19, 2013 4:25 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:01 AM
Points: 48, Visits: 151

Hi,

Using SQL Row Versioning is there is any possibility to get the history of row data from the updated table.

And also can any one tell me what is difference of Read committed isolation and Snapshot isolation level row version in simple words, Wink

Post #1421542

anthony.green

Posted Tuesday, February 19, 2013 4:35 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Row Versioning? You mean adding a timestamp column to the table which changes when rows are updated etc? - No there is no way to know the old data. You could look at using CDC or implimenting triggers but could cause you more problems.

The difference between the two DB level snapshots is that 1 keeps the row version alive until the oldest session no longer needs it, the other keeps it alive until the oldest transaction no longer needs it. IIRC

http://msdn.microsoft.com/en-us/library/ms189050%28v=sql.105%29.aspx

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421548

ratheesh4sql

Posted Tuesday, February 19, 2013 4:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:01 AM
Points: 48, Visits: 151

Thank you very much for you reply....

So which is recommended Row Versioning in sql? how to decide it...?

Post #1421557

anthony.green

Posted Tuesday, February 19, 2013 4:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You decide if you need row versioning on a table or not, its there to tell you when a row has changed, hence the timestamp hash changes. Its not an audit of what it was to what it is, for that you need CDC or custom auditing.

Post #1421559

« Prev Topic | Next Topic »

Permissions