• Delete rows in batches and don't forget to rebuild the indexes after deletes based on fragmentation percentage.