Dev-812464 (8/16/2012)
From application in 2005 it was taking 22 mins to bulkinsert 10,000 Items, but in 2008 its taking 39 mins. While insert is running I am not able to select anything from the database.
10,000 rows is not that many. 22 minutes seems like a long time for this many rows. (I bulk insert millions of rows and rebuild indexes in less than 5 minutes) How many columns and what data types are there? What batch size are your using and what about the recovery mode of the database? (are your using a staging database?)
What kind of indexes are on the table? are you bulk inserting into stage table or the actual table?
So many things can affect bulk insert performance, we would need to know all of the details.
The probability of survival is inversely proportional to the angle of arrival.