您要查找的是不是:
- Row versioning information is stored in each fragment used to store these large strings. 行版本控制信息存储在用于存储这些大型字符串的每个片段中。
- Each database row may use up to 14 bytes at the end of the row for row versioning information. 每个数据库行的结尾处最多可以使用14个字节记录行版本控制信息。
- The isolation level under which a Transact-SQL statement executes determines its locking and row versioning behavior. 执行Transact-SQL语句所使用的隔离级别确定其锁定行为和行版本化行为。
- Describes the benefits and costs of row versioning, and gives recommendations for the scenarios best suited to row versioning. 介绍行版本控制的好处和成本,提供有关最适合行版本控制的方案的建议。
- The hints specify the type of locking or row versioning the instance of the Microsoft SQL Server Database Engine uses for the table data. 提示指定Microsoft SQL Server数据库引擎实例用于表数据的锁类型或行版本控制。
- Locking and row versioning prevent users from reading uncommitted data and prevent multiple users from attempting to change the same data at the same time. 锁定和行版本控制可以防止用户读取未提交的数据,还可以防止多个用户尝试同时更改同一数据。
- Snapshot isolation, by contrast, depends on enhancements to row versioning and is intended to improve performance by avoiding reader-writer blocking scenarios. 相反,快照隔离依赖于行版本控制的增强功能,旨在通过避免读取器和编写器的阻止情况,来提高性能。
- Adding the row versioning information can cause index page splits or the allocation of a new data page if there is not enough space available on the current page. 如果当前页上没有足够的可用空间,则添加行版本控制信息会导致拆分索引页或分配新的数据页。
- The snapshot isolation level implements row versioning to provide users with a view of the data in the database as it existed when the current transaction started. 快照隔离级别实现行版本控制,用来为用户提供在当前事务启动时数据库中数据存在状态的视图。
- A unique transaction sequence number identifies each transaction, and these unique numbers are recorded for each row version. 唯一的事务序列号标识每个事务,并且为每个行版本记录这些唯一的编号。
- Many of the counters in the Transaction object can be used to monitor the size and rate of growth of the row version store in tempdb. Transaction对象中的许多计数器可用来监视tempdb中的行版本存储区的大小和增长速率。
- If the PreserveChanges flag is set to false, incoming values do overwrite the existing values in the Current row version of the existing row. 如果preserveChanges标志设置为false,传入值则将重写现有行Current行版本中的现有值。
- If the preserveChanges parameter is set to false, incoming values do overwrite the existing values in the Current row version of the existing row. 如果preserveChanges参数设置为false,则传入值将改写现有行的Current行版本中的现有值。
- Row versioning removes the need for requesting share locks on rows that have been read. 行版本控制不需要对已读取的行请求共享锁。
- The row versioning information contains the transaction sequence number of the transaction that committed the version and the pointer to the versioned row. 行版本控制信息包含提交版本的事务的事务序列号和指向版本行的指针。
- Row versions that are generated by data modification transactions in a database that uses read-committed using row versioning isolation or snapshot isolation transactions. 由使用已提交读的快照隔离或快照隔离事务的数据库中数据修改事务生成的行版本。
- Row versions that are generated by data modification transactions in a database that uses snapshot or read committed using row versioning isolation levels. 由使用已提交读快照隔离或快照隔离级别的数据库中的数据修改事务生成的行版本。
- This activates the mechanism for storing row versions in the temporary database (tempdb). 这样将激活在临时数据库(tempdb)中存储行版本的机制。
- All read operations view row versions that were committed at the time a statement started. 所有读操作都将查看语句启动时已提交的行版本。
- A row state indicates the status of a row; row versions maintain the values stored in a row as it is modified, including current, original, and default values. 行状态指示行的状态;行版本在修改行中存储的值时维护各个阶段的值,包括当前值、原始值和默认值。
