I have an application that tracks a weekly SLA for something, and resets at the end of the week.
the table used is ONLY used for that, and so, we need to essentially empty the table at the end of the week. (Sunday midnight)
Question - which is better (for size and performance)
a) - just delete all rows?
b) - drop the table and recreate
its a ms SQL database.
the table used is ONLY used for that, and so, we need to essentially empty the table at the end of the week. (Sunday midnight)
Question - which is better (for size and performance)
a) - just delete all rows?
b) - drop the table and recreate
its a ms SQL database.