Using Sql Azure with entity framework. Most of our tables have a date column where we store when the record was edited and by whom. Is there a benefit of making those columns into a timestamp column for the following reasons
- Does timestamp help if we want to synchronize this db with another db with SQL Data Sync i.e. if we have a timestamp column that we can use both for our logging and data sync especially if data sync insists on all the tables having a timestamp column
- Will having this column help with optimistic concurrency (via entity framework)?
DATETIME
type has an accuracy of only 3.33ms ? To me, that's not accurate enough for a timestamping that I need for concurrency checks.... theTIMESTAMP
(or now:ROWVERSION
) datatype is much better in that it provides consecutive binary-encoded numbers everytime something changes - no matter how close after another event - the value will be different (no problem with time accuracy) – marc_s