2 ms·
You may have been the straw that broke the camel's back, but you shouldn't feel bad about that. I recently had a junior sysadmin learn the hard way about BEGIN
by MichaelGG 13y ago
You may have been the straw that broke the camel's back, but you shouldn't feel bad about that. I recently had a junior sysadmin learn the hard way about BEGIN TRAN/ROLLBACK/COMMIT. But that's all it was, an embarrassing lesson as he explained to a customer why they'd need to wait a little bit longer.
Even a major "DELETE FROM Foo" should just immediately get the DBA switching to read-only mode, and then restoring using the transaction logs. It's annoying, it causes a bit of downtime, but it's not a "Big Deal".