Comment by Cody_C

I have found soft deletes to be really helpful to preserve historical references and as a simple but reversible enable disable switch.

Sometimes a really destructive delete isn't something you want to do by default.

I have seen them abused and a lot of times queries forget to take the flag into account. Every decision is a trade-off.