If this is an ongoing issue, you may want to look at partitioned tables. You can truncate a single partition of a table.