Hacker News new | ask | show | jobs
by hmr 1826 days ago
It was my third year of my first job, I was alone working on the live database. I ran the following SQL command in SSMS:

DELETE FROM TABLE WHERE ID = something

And the table had a million records. Guess what!

In SSMS, the DELETE FROM TABLE was selected.

It took an hour to restore from backup, it stopped a lot of people from working, many new records was lost, they had to keep pile of papers to enter into syatem again.