I have a program that is beginning to time out because the DB it is relying on is growing too large. I want to delete older data, but am not sure on the best way to do this. If a stored procedure, how do you delete data older than, say, a month?
You would need some column in your table that has a datetime field. Or join to a table that has some date time field. There is no marking in SQL Server of the date a row was inserted.