Versions Compared

Old Version 4

changes.mady.by.user admin

Saved on

compared with

New Version 5

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleREAD_COMMITTED_SNAPSHOT vs ALLOW_SNAPSHOT_ISOLATION

We recommend setting the READ_COMMITTED_SNAPSHOT database option ON. If you set the READ_COMMITTED_SNAPSHOT database option to ON, the database engine uses row versioning and snapshot isolation as the default, instead of using locks to protect the data. In this This topic also discusses setting ALLOW_SNAPSHOT_ISOLATION database option ON. This isolation state can be used but is not required as per Aptify's analysis and testing. 

...