How to copy a huge table data into another table in SQL Server
I had the same problem, except I have a table with 2 billion rows, so the log file would grow to no end if I did this, even with the recovery model set to Bulk-Logging: insert into newtable select * from oldtable So I operate on blocks of data. This way, if the transfer is … Read more