Geek asks and answers

SQL Server 2008: Bulk Insert Forever

I have a txt file (with a tab delimiter) that has almost 1200 entries. I perform a bulk insert operation to get data from a .txt file into a table that (structure) has already been created in the database. I do not know why mass insertion takes forever. Any suggestions on where / what / how to check what triggers this operation forever? Thank you I did this before and it worked fine. Any reasons?

BULK INSERT DataFromatltemp
 FROM '\\abcd\Admin\temp\Copyatltemp07.txt'
 WITH
 (
  FIELDTERMINATOR = '\t',
  ROWTERMINATOR = '\n'
 )
GO
0
source share
1 answer

Like almost everything related to RDBMS and performance, it depends on a number of variables, but there are a few tips that you can see in the first place:

  • : make sure your database uses easy recovery mode;
  • : ( , );
  • : ;
  • : , - ;
  • : , ;

, .

-1

More articles:


All Articles