im currently designing a database. i usually design my tables with "LastUpdate" field with a smalldatetime data type for tracking purpose. which is whenever user insert or update a row. there's a trigger that updates that specific field.
now, i was thinking to split the information of "created date" and the "last update" of that row. is this advisable or necessary in general? i don't see anything wrong with it except extra data space. i'd like to check some third opinion before proceeding.
P.S im using SQL Server 2008 R2 ;)