Unanswered: large table loads & transaction log issues
I have a table thatís about 3 gigs, using this table and a few others Iím making another table. The problem is when making the new table my transaction log inflates so much that Iím running out of disk space. What I can I do to prevent this or to keep the transaction log size under control?
You need to either try SELECT * INTO new_table FROM old_table, or BCP out from the old table and BULK INSERT/BCP into the new one. When doing BCP IN/BULK INSERT make sure to specify BATCH SIZE, something like 10,000. Also use WITH TABLOCK while doing BULK INSERT.