The trouble with soft delete

Today I would like to write about a very common pattern seen in database-driven business applications — soft delete — why it fails in large applications, and some better alternative strategies.