Phil Parkin (6/22/2009)
I am now going to add a few derived columns - I thought "Create_Date" and "Change_Date" might be very useful for tracking updates.
You might also consider doing these at the database level. Your CreateDate field just needs a DefaultValue of GetDate() and ChangeDate needs an UPDATE trigger to keep it maintained ...
I think that depends on what you are after. I routinely use column defaults on CreateDate columns in OLTP systems. For OLAP or data warehouse DBs, I typically use a LoadDate column when loading data and I assign the LoadDate value from a variable in the SSIS package that gets its value at SSIS startup time so that everything that was loaded as part of the SSIS package run has the same LoadDate.
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden