dalenewman/Use Snapshot Isolation for Transformalize MSSQL Databases

Created August 2, 2016 12:33

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dalenewman/9ac2b270c0929ae8bca2382aa3dd6539.js"></script>
Save dalenewman/9ac2b270c0929ae8bca2382aa3dd6539 to your computer and use it in GitHub Desktop.

Download ZIP

SnapShotIsolation.sql

Raw

Use Snapshot Isolation for Transformalize MSSQL Databases

	ALTER DATABASE MyDatabase
	SET ALLOW_SNAPSHOT_ISOLATION ON

	ALTER DATABASE MyDatabase
	SET READ_COMMITTED_SNAPSHOT ON

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment