O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transactions and Memory-Optimized Tables

As described previously in the sections describing the in-memory data row and index structures, SQL Server In-Memory OLTP uses row-versioning to determine which row versions are visible to which transactions. This is accomplished by maintaining an internal Transaction ID that serves the purpose of a timestamp. The timestamps are monotonically increasing every time a transaction commits. A transaction’s start time is the timestamp in the database at the time the transaction starts. When the transaction commits, it generates a new timestamp, the Global Transaction Timestamp, which is used to uniquely identify that transaction. Timestamps are used to specify the following:

Commit/End Time—The distinct point ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required