August 29, 2017 at 3:50 pm
If a database table does not have a last modified date time column is there a way to determine when that column was last updated or inserted into a table? I want to run an ETL against a table and only extract records that are recently changed or inserted.
I've heard auditing is an option. Doesn't that cause a performance hit?
Thanks for any constructive feedback.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 29, 2017 at 4:19 pm
No, not without a modified column, and that must have a default of GetDate() or SysDateTime() or a trigger.
August 30, 2017 at 5:39 am
Joe Torre - Tuesday, August 29, 2017 4:19 PMNo, not without a modified column, and that must have a default of GetDate() or SysDateTime() or a trigger.
There's more to it than just adding a date column with a default, as I am sure you know.
Change Tracking may be worth investigating.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply