||A row identifier used to lock a single row within a heap.
||A single row is locked - index key for a single row in an index.
||An 8-kilobyte (KB) page in a database, such as data or index pages.
||A lock on an extent (=a contiguous group of 8 pages, such as data or index pages). Used, for example, when an
ALTER INDEX REBUILD command is executed on a table and the pages of the table may be moved from an existing extent to a new extent.
||It acts like a table-level lock, but on a partition instead of on the table itself.
||The entire table, including all data and indexes => blocks all write requests on the entire table (including indexes), it can significantly hurt database concurrency.
||A database file.
||An application-specified resource.
||The table schema definition is locked.
||An allocation unit.
||The entire database.