How to delete records base on a date and offset

Question

I need to delete records in a table if the current date is greater than the record creation date + a preset number of days (defined by @numberOfDays). I am using the following SQL statement but am not sure if it’s very efficient. Is there a better way?

I am using MS SQL 2008 server.

DELETE
FROM deviceManager.Test2
WHERE DATEADD(day, @numberOfDays, deviceManager.Test2.GeneratedAt_UTC) < SYSDATETIMEOFFSET()

@numberOfDays is an int with a value of 10

Answer 1

Seems OK to me, I can't think of a better way off the top of my head.

Answer 2

Probably better to adjust the current date instead of every record in the table. Change the logic to "record creation date is before current datetime - @numberOfDays."

This is more efficient - one calculation instead of many.