I would like to add a datetime column to a table that will contain the date of when the row was inserted into the table. This is for debugging purposes.
The person who is in charge of this particular database refuses to do it claiming it will slow down inserts and take up too much storage!
We have about 4.5 million records and insert about 1.5 million records a day which will grow. The code is in C# using LINQ to access the SQL Server 2008 database. Do you agree with him that this will really slow down inserts?
Does anyone have any statistics or algorithms to figure out how much more time it would take to do an insert with a getDate() for an additional column? And how to figure out how much storage it would take to add a datetime column for 5 million records? Any suggestions are welcomed.