Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
SQL SERVER – Troubleshooting Common CSV Import Issues
Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
STRING_SPLIT arrived in SQL Server 2016 but is still underused. Here is how to split comma separated value string in a column into rows, quickly.
SQL SERVER – SSMS Trick – Generating CSV file using Management Studio
Readers asked why use SQLCMD or BCP at all. Generating CSV file output is easy in SSMS: set Results to Text as comma delimited in Tools, Options.
MySQL – Export the Resultset to CSV file
In MySQL you can export a resultset to CSV in more than one way. I show two methods: the Export option in Workbench and the INTO OUTFILE command.
SQL SERVER – Export Data AS CSV from Database Using SQLCMD
We often import CSV into SQL Server, but how do you export data as CSV with SQLCMD? Two simple commands, one with column headers and one without.
Sharing Query Results From SSMS: Copy With Headers, Grids and CSV
Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.