O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Transaction Handling

Database Engines aren’t designed to simply store data. A core feature of any Database Engine is to ensure data consistency while allowing the maximum concurrent access to your data. If data within your SQL Server databases never changed, the issue of data consistency would never occur. However, one user can change data while other users are attempting to read the same data.

Each time a user makes a change to data, they can decide to either save the change, COMMIT, or discard the change, ROLLBACK. SQL Server has to ensure that users reading data always receive data that has been committed to the database in order to ensure consistent results.

Each unit of work that you submit to SQL Server is a transaction. Each transaction is ...

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