title: SQL speed up performance of insert?
body: <p>I am performing some test on sql server and I want to get the best insert speed possible. 
  The statement I use is something like this: </p>
  
  <pre><code>INSERT INTO db_Test_databse..tbl_test with(rowlock)  
     (  joinid, date_key,   
        col1, col2,col3,col4, col5, col6, col7, col8, col9, col10,  ...     
     )  
  
  SELECT  tabid as joinid, 
          date_key,
          rec_type,  
          col2,  
          dbo.udf_convert_hex_to_dec(col3),  
          col4, col5, col6, col7, col8,  
          dbo.udf_convert_hex_to_dec(col9),  
          dbo.udf_convert_hex_to_dec(col10),  
          ...
  from source_table f
  </code></pre>
  
  <p>There are 25 columns; most of them are of type bigint or int. </p>
  
  <p>I dropped all indexes from the destination table except the primary key which is an identity field. </p>
  
  <p>Any tips on how to improve the performance more?</p>
  
  <p>P.s. In this form I have an average speed of 16.000 rows / sec.</p>