1efba03e   
   From: esquel@sommarskog.se   
      
   OM (oranmeir@gmail.com) writes:   
   > is there an option to increase the time of inserting 1M rows to a   
   > table using stored procedure?   
   >   
   > Already removed all the indexes and the database is on Raid 10/   
      
   There are certainly several options. BULK INSERT or BCP is probably   
   the fastest. But you say "with a stored procedure". Where does the   
   data come from? How does your current solution look like? And which   
   version of SQL Server are you using?   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)