Very large SQL Server 2016 result sets (over 75 GB) to a CSV file?

7 votes

3 answers

4843 views

sql-server sql-server-2016 export csv bcp

                          What is the best way to get very large SQL Server 2016 result sets (over 75 GB) to a CSV file? The engineers need this output to look for correlations.

The bcp route for a 73.5 GB file filled up tempdb and started crashing other applications, including the ETL process. 

Our users want to export up to 500 GB.

What process would use the least amount of resources so that other applications keep running?

Asked by Alex (79 rep)

Oct 3, 2017, 04:50 PM
Last activity: Jan 5, 2023, 12:22 PM

Very large SQL Server 2016 result sets (over 75 GB) to a CSV file?

Related Questions