Always Commit() or Rollback() an Transaction when you are done with it.

Use try/catch blocks to ensure that you either Commit() the partially completed transaction or Rollback() the transaction if an exception is raised during processing.

Endeavour to keep transactions open for as short a time as possible - an open transaction can potentially block not only other database writers but also other database readers. If you have a large number of updates to perform we recommend that you break them down into smaller batches that each execute within a single transaction.