title: Fastest way for inserting very large number of records into a Table in SQL
body: <p>The problem is, we have a huge number of records (more than a million) to be inserted into a single table from a Java application. The records are created by the Java code, it's not a move from another table, so INSERT/SELECT won't help.</p>
  
  <p>Currently, my bottleneck is the INSERT statements. I'm using PreparedStatement to speed-up the process, but I can't get more than 50 recods per second on a normal server. The table is not complicated at all, and there are no indexes defined on it.</p>
  
  <p>The process takes too long, and the time it takes will make problems.</p>
  
  <p>What can I do to get the maximum speed (INSERT per second) possible?</p>
  
  <p>Database: MS SQL 2008. Application: Java-based, using Microsoft JDBC driver.</p>