In this tip, I show how soft deletes and a filtered index can help minimize the cost of ghost records in an Availability Group.