Row header

The row header is split into five sections:

  • Begin Ts: This is the timestamp of the transaction that inserted the row into the database.
  • End Ts: This is the timestamp of the transaction that deleted the row from the database. For rows that have not yet been deleted, this field contains a value infinity.
  • StmtId: This field stores a unique statement ID corresponding to the statement inside the transaction that created this row.
  • IdxLinkCount: This field is a counter for the number of indexes that reference this row. An In-Memory table stores data only and has no reference to other rows in the table. The indexes that are linked to the table control which rows belong together.
  • Finally, we have a set of pointers that reference the indexes ...

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.