After having done "deleted_at" for years, we prefer systems like MSSQL Temporal Tables. Otherwise, managing a deleted_at column is something you have to remember to account for in indexes and in all queries.
Instead, just nuke that row and have a copy in a separate time-based table.
Instead, just nuke that row and have a copy in a separate time-based table.
https://learn.microsoft.com/en-us/sql/relational-databases/t...