Click here to Skip to main content
15,881,559 members
Articles / Database Development / SQL Server

Data Versioning in SQL Server using Snapshot a.k.a. Row Versions

Rate me:
Please Sign up or sign in to vote.
4.34/5 (23 votes)
7 Feb 2018CPOL5 min read 66.4K   198   35  
Enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems using Snapshots
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems. This is done by enabling snapshot isolation.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
Europe Europe
Biography provided

Comments and Discussions