I need to delete older than year 2009 records from table and keep only year 2010 and above records in the table. It is almost 1 million records to delete.
I thought of deleting records using below script but it will create transaction log in the database. So please let me know the best method to delete records from the table.
Delete from tablename where reportdate <= 20090101