sp_BulkExport:Export Data from TSQL without using xp_cmdshell - uses SQLDMO and sp_OA*. Supports a variety of formats and options. In my testing on a 22 million-row table it is NOT as fast as BCP. This is the first rev of the proc and it has not been thoroughly tested.
2004-09-16 (first published: 2004-06-25)
935 reads
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Powershell script to generate SQL...
Comments posted to this topic are about the item Database Ledger in SQL Server...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers