title: How to export fast large tables from SQL Server to csv?
body: <p>I am trying to export large (10 million rows) table to a semicolon separated <code>.csv</code> file. I am currently using build in tool (Import/Export Wizard) in Microsoft SQL Server Management Studio v17 and the export takes approximately 5 hours.</p>
  <p>Is there a simple way to speed up this process?</p>
  <p>I am limited by my company to use only R/python solution, beside of course SQL Server itself.</p>