You are writing an application that accesses a single Microsoft SQL Server database. You must use transactions to ensure consistency between two of the database tables. You must choose the transaction type with the least impact on performance.

What should you do?

Transactions are most efficient when they are performed on the server. If you are working with a SQL Server database that makes extensive use of explicit transactions, consider writing them as stored procedures using the Transact-SQL BEGIN TRANSACTION statement.

Local transactions incur more overhead than transactions performed on the server.