- Changed type Naomi NModerator 12 hours 42 minutes ago question
I have a process doing 80 million inserts to a table.How to increase the inserting speed to sql table. SQL 2014 edition
I have a process doing 80 million inserts to a table.How to increase the inserting speed to sql table. SQL 2014 edition. Already removed the unused indexes and only the required indexes are present in the table.
September 7th, 2015 8:29am
Read this article
http://www.dfarber.com/computer-consulting-blog.aspx?filterby=Batch%20processing%20records%20in%20MS%20SQL
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 8:35am
Hi ,
Use BCP/BULK INSERT/OPENROWSET(BULK)/DTS/SSIS.
September 7th, 2015 8:38am
I have a process doing 80 million inserts to a table.How to increase the inserting speed to sql table. SQL 2014 edition. Already removed the unused indexes and only the required indexes are present in the table.
I suggest you to read below document
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 10:00am
Is this table used during the load?
How many rows in the table to start with?
Can you post the DDL?
September 7th, 2015 11:21pm
it is a truncate and load. The table is loaded from a sql commands coming in from informatica. I am seeing if some configuration change in sql level can increase the inserting speed.
Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 2:56am