Viewing 7 posts - 1 through 7 (of 7 total)
Something else to think about... I needed to be able to use the BULK LOGGED recovery model and I'm pretty sure that both of these methods (CDC and CT)...
December 16, 2019 at 7:14 am
My personal feeling is that CDC is incredible overkill for simple DML logging of historical data both in complexity of use and design as well as causing excessive duplication...
December 15, 2019 at 4:18 pm
First of all thanks for your input much appreciated. The trigger sounds like an interesting approach although I have heard that they are not good performance wise...
December 15, 2019 at 10:45 am
Thanks to everyone who chimed in...I’m trying to figure out how to reply directly to a comment but haven’t got there yet 🙂
December 14, 2019 at 5:44 pm
Just to answer the question in relation to indexes & constraints on the fact table. Currently history is being tracked in the fact table using the SCD Type2 approach but...
December 14, 2019 at 5:42 pm
First of all thanks for your input much appreciated. The trigger sounds like an interesting approach although I have heard that they are not good performance wise (I am...
December 14, 2019 at 5:26 pm
Just to add that I am currently using SQL Server 2012 so don’t have temporal table functionality available in 2016
December 7, 2019 at 6:21 pm