So You Want To Implement Soft Deletes In SQL Server
Thanks for watching!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Another nice video, thanks.
You know, I generally hate the subscriptions, but you are the one youtuber (no offense meant) that I would consider supporting on regular basis on Patreon or something.
Eh, maybe I just buy your training video bundle to show support.
Ha ha, no offense taken. There are memberships for my YouTube channel, but apparently getting to them is a hassle.
Great stuff!
We use a DATETIME2 column for our soft deletes to enable access to historical transactions on an entity. I don´t like it but it´s whats required.
Great SQL like AND(Item.Deleted IS NULL OR trn.Created <= Item.Deleted) 🙁
That seems like a good use for canary values, like 99991231, but with a good index it might not matter so much.