I need this requirement:
- Delete records leaving records of the last 60 days.
- The range of debugging for the deletion of records is 3 months. Within these three months should eliminate blocks of 500 by 500.
Since this table contains a lot of records, it is necessary to clean the table for periods, considering the date
I am using sql server 2005, i can not use cursor.
You need to clear the transaction records 500 records without locking the entire table completely and releasing locks on each transaction