ad 1) Create a stored procedures that is scheduled to run daily (or how often you need it). The body might look something like that
DELETE <table>
WHERE
DumpDate <= DATEADD(day, -7, GETDATE())
Depending on your requirements, you might want to remove the time portion contained in GETDATE()
ad 2) Not sure I would want this as another column in the table as you can easily generate this information during runtime with a simple DATEDIFF(millisecond, Startime, Endtime) which obviously gives you the duration in milliseconds.
--
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderator
http://www.sql-server-performance.comWebmaster:
http://www.insidesql.org