Lesson Learned #17: Should I cancel or kill a session running a huge transaction?

Hello Everyone,   We are receiving multiple service requests where our customers cancelled or kill a session that was running a huge transaction (delete/insert/update). After this cancelation, they were waiting for the same time that the huge transaction took to be able to do any action with the tables involved in this transaction. This situation is normal in any SQL Server edition,…