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.

• Changed type Naomi NModerator 13 hours 19 minutes ago question

Read this article

http://www.dfarber.com/computer-consulting-blog.aspx?filterby=Batch%20processing%20records%20in%20MS%20SQL

Hi ,

 Use BCP/BULK INSERT/OPENROWSET(BULK)/DTS/SSIS.

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

Data Load performance guide

Is this table used during the load?

How many rows in the table to start with?

Can you post the DDL?

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.

Meaning ,you have a linked server ?