How SQL Server 2000 Modifies Data

To guarantee consistency and recoverability of the information, SQL Server considers every data modification as part of a transaction. It will record transaction information, and every modification made as part of every transaction, in a transaction log. In other words, SQL Server first records how the data will be modified, and then it modifies the data. The logical process could be explained as follows:

  1. A data modification is requested.

  2. SQL Server creates a query plan to execute the data modification request.

  3. SQL Server starts a transaction and records it in the transaction log.

  4. SQL Server writes every operation to apply to the data in the transaction log before modifying the data.

  5. After the operations are registered ...

Get Microsoft® SQL Server™ 2000 Programming by Example 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.

Start your free trial