Deleting rows when DB grows too large

  • 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.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply