When dropping or rebuilding tables and indexes that use more than 128 extents, SQL Server 2005 defers the actual page deallocations, and their associated locks, until after a transaction commits.

  • 当删除或重新生成使用超过128个区的表和索引时,SQL Server 2005将实际的页释放及其关联的锁迟延到提交事务之后。
目录 查词历史