How to Code Efficient Transactions in Microsoft SQL Server

To Code efficient transactions in Microsoft SQL Server, We must take care of following things :

1. Don't allow input from users during a transaction.
2. Don't open transactions while browsing through data.
3. Keep the transaction as short as possible.
4. Use lower transaction isolation levels.
5. Access the least amount of data possible while in a transaction.

See Also