Is CLR or BCP Faster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Is CLR or BCP Faster

When writing a file (CSV or TXT) as output of a select statement, CLR or BCP (Bulk Copy Program) faster?
CLR is using StreamWriter(C#) to output the content to file.
it is BCP —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>