Click here to Skip to main content
15,885,985 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.5K   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.

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

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