InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:36:21 GMT20http://www.sqlservercentral.com/Forums/Topic1426230-373-1.aspxBest way to determine this is to setup a test environment and do it both ways. Using a default will alleviate the need for the developers to code for inserting the current dateJust remember, a default is only used if the column isn't included in the INSERT. If it is included and an invalid or simply incorrect date (including NULL if permitted) will prevent the DEFAULT from being inserted.Mon, 04 Mar 2013 07:20:15 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1426230-373-1.aspxHi,I am creating a new Database. In this i will have a column for to store current Date.I can specify it as a default Constraint with GetDate() or ask the developers to insert it themselves.My doubt is which will give the best performance since the database will hold millions of records.Thanks in advance,KarthickMon, 04 Mar 2013 07:14:26 GMTard5karthick