How to delete large number of records from SQL Server 2008 R2 Table?
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.