I'm curious as to how the performance impact and usability of the trigger pattern is in comparison to the StartDate and EndDate column pattern where the most recent row has an EndDate of NULL. Then you use an indexed view over the table with a "where EndDate IS NULL" clause.

Anyone choose between the two and why?

I'm inclined to use the StartDate and EndDate pattern when tracking changes across all columns.

*** Edited for appreciation comment ***

Thank you for the video, well done!