您要查找的是不是：
- When rows are deleted from a heap the Database Engine may use row or page locking for the operation. 从堆中删除行时,数据库引擎可以使用行锁定或页锁定进行操作。
- Below is a list of page locks and unlocks. 下面是页面锁定和取消锁定的列表。
- Specifies whether page locks are allowed. 指定是否允许页锁。
- The Database Engine can still acquire an intent page lock (IS, IU or IX) for internal purposes. 数据库引擎仍然可以获取意向页锁(IS、IU或IX),以供内部使用。
- The Database Engine chooses the appropriate lock and can escalate the lock from a row or page lock to a table lock. 数据库引擎将选择相应的锁,并且可以将锁从行锁或页锁升级到表锁。
- Using the TABLOCK hint causes the delete operation to take a shared lock on the table instead of a row or page lock. 使用TABLOCK提示会导致删除操作获取表的共享锁,而不是行锁或页锁。
- This removes the requirement to examine every row or page lock on the table to determine if a transaction can lock the entire table. 而不需要检查表中的每行或每页上的锁以确定事务是否可以锁定整个表。
- Similarly, page locks are always escalated to table locks. 同样,页锁始终升级到表锁。
- The Database Engine might do both row and page locking for the same statement to minimize the number of locks and reduce the likelihood that lock escalation will be necessary. 数据库引擎可以为同一语句执行行锁定和页锁定,以最大程度地减少锁的数量,并降低需要进行锁升级的可能性。
- Takes page locks either where individual locks are ordinarily taken on rows or keys, or where a single table lock is ordinarily taken. 在通常行或键采用单个锁的地方,或者通常采用单个表锁的地方,请采用页锁。
- The Database Engine does not escalate row or key-range locks to page locks, but escalates them directly to table locks. 数据库引擎不会将行锁或键范围锁升级到页锁,而是将它们直接升级到表锁。
- The SQL Server 2005 Database Engine will not escalate row or page locks to table locks. SQL Server 2005数据库引擎不会将行锁或页锁升级到表锁。
- He chiseled a hole in the door to fit a new lock. 他在门上凿了个孔，以便装一把新锁。
- When the total of intent locks, row locks and page locks on a specific table exceeds the escalation threshold, escalation occurs. 当特定表上意向锁、行锁和页锁的总数超出升级阈值时,就会进行升级。
- This lock can only be opened from the inside. 这把锁只能从里面打开。
- He put the key in the lock and turned it. 他把钥匙插入锁里转动。
- We must put a new lock on the front door. 我们得在前门上安一把新锁。
- Someone has been tampering with the lock. 有人乱动过这把锁。
- Someone has to lock up the house. 总要有人把房子锁起来。
- The printer can set this additional page in here. 这位印刷工把这额外的一页加在这里。
