Database ยท SQL Server
How would you handle a practical scenario involving Transactions in SQL Server?
For an order creation process that writes order, items, and payment status, explain what belongs in one transaction and what should be handled asynchronously.