How do you decide transaction boundaries? What belongs inside a transaction and what does not?

Question

Accepted Answer

A transaction boundary is the smallest span of work that must be atomic and consistent as a unit. The rule of thumb: start it as late as possible, end it as early as possible, and keep everything inside it under the control of a single database.