I need to insert data from one table to another table. Currently i am using below statement:
INSERT INTO TABLE_2
SELECT * FROM TABLE_1with (nolock)
The table_1 contains heavy records (in corers) and log file size is growing very high and also it was taking 9-10 hours (1107052852 rows) to insert.
Is there any other way to speed up my insert statement & to minimize log file size growth.
NOTE: 1. table_2 already exist in database with same structure of table_1.
2. one clustered index and one nonclustered indexes are there in both the tables.
3. I have tried with Heap table method (no indexes) but no use.