Top "Bulkinsert" questions

Act of inserting multiple rows into a database simultaneously.

Add primary key to a table with many records

I have a table in SQL Server 2005 containing 10000054 records; these records are inserted through a bulk insert operation. The table …

sql-server primary-key bulkinsert
Improve insert performance massively

In my application I need to massively improve insert performance. Example: A file with about 21K records takes over 100 min …

spring-data-jpa bulkinsert
pyodbc - very slow bulk insert speed

With this table: CREATE TABLE test_insert ( col1 INT, col2 VARCHAR(10), col3 DATE ) the following code takes 40 seconds to run: …

sql-server bulkinsert pyodbc
django bulk create ignore duplicates

I'm trying to bulk insert into a MySQL db for a very large dataset and would love to use django's …

python mysql django bulkinsert bulk
SQL SERVER bulk insert ignore deformed lines

I have to import SAP unconvered lists. These reports look quite ugly and are not that well suited for automated …

sql sql-server sql-server-2008 bulkinsert openrowset
Dynamics CRM 2011 Bulk Update

Running Dynamics CRM 2011 rollout 3. Need to update millions of customer records periodically (delta updates). Using standard update (one by one) …

dynamics-crm dynamics-crm-2011 bulkinsert
Inserts of stateless session of NHibernate are slow

It's been a couple of days that I'm working on improving NHibernate Insert performance. I'd read in many posts (such …

c# nhibernate fluent-nhibernate bulkinsert stateless-session
How to use BULK INSERT when rows depend on foreign keys values?

My question is related to this one I asked on ServerFault. Based on this, I've considered the use of BULK …

tsql memory foreign-keys bulkinsert
BULK INSERT into specific columns?

I want to bulk insert columns of a csv file to specific columns of a destination table. Description - destination …

sql sql-server sql-server-2005 bulkinsert
SELECT FROM OPENROWSET( BULK...) changing special characters

I've been facing an issue for a few hours, and I can't seem to get my head around this one. …

sql-server sql-server-2008 bulkinsert collation openrowset