This operation is called copy on write and is used for all inserts, updates and deletes using this technique. When data is modified, the committed versions of affected rows are copied to tempdb and given version numbers. Snapshot isolation avoids most locking and blocking by using row versioning.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |