Tagged Questions
1
vote
1answer
245 views
Importing large file while keeping table available for other operations
We need to import millions of rows in a quite big table.
Say like 5 million rows into a table with more than 1 billion rows.
After preprocessing the import file we will have update operations and ...
5
votes
2answers
2k views
BULK INSERT - best usage
I need to export 150 million rows of only int/bigint columns from one SQL instance to another. I am using BCP queryout to export the rows and BULK INSERT to import the rows to another table.
I split ...
