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

Row Versioning Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 4:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 6:46 AM
Points: 49, Visits: 176
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,
Post #1421542
Posted Tuesday, February 19, 2013 4:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 AM
Points: 5,231, Visits: 5,106
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
Posted Tuesday, February 19, 2013 4:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 6:46 AM
Points: 49, Visits: 176
Thank you very much for you reply....

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

Post #1421557
Posted Tuesday, February 19, 2013 4:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 AM
Points: 5,231, Visits: 5,106
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.



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 #1421559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse