Currently i am running below mentioned insert statment in one of my user database.The destination table is partioned table & it contains 2 indexes (one clustered and one non-clustred).
Insert into table_1
select * from table_2
The problem is: tempdb log file size is growing very high. So i am planning to shrink log file (same time that is insert statment is executing, alternatively i am planning to shrink log file).
by performing to transactions at same, is there any impact on my source/destination tables.
The reason is tempdb is located in seprate drive (the size is very low).
So i am planning to shrink tempdb log file.
please let me know
1. is there any impact on source/destination table?
2. is there any impact on tempdb?