What are the best practices and options for implementing version history and audit trails in SQL Server tables, focusing on displaying who changed what and when with quick queries, using Slowly Changing Dimension Type 2 and Type 4 as examples?
Curious if there is a one best way to do it? How do enterprise applications deal with version history?