O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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

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 ...

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