title: How to quickly export data from R to SQL Server
body: <p>The standard RODBC package's <code>sqlSave</code> function even as a single <code>INSERT</code> statement (parameter <code>fast = TRUE</code>) is terribly slow for large amounts of data due to non-minimal loading. How would I write data to my SQL server with minimal logging so it writes much more quickly?</p>
  
  <p>Currently trying:</p>
  
  <pre><code>toSQL = data.frame(...);
  sqlSave(channel,toSQL,tablename="Table1",rownames=FALSE,colnames=FALSE,safer=FALSE,fast=TRUE);
  </code></pre>