Actually, just had cause to revisit this particular thread...
... and it just dawned on me that tests in the article are not
measuring the performance of each method... the tests are measuring how well each method runs a loop which has nothing to do with transferring data to a file. If you want a real test, build a table with desired number of rows (100k for example) and then simply select from that table using each method. The results will be drastically different.
Here's how to build a 100k row table of numbers in an eye-blink...
SELECT TOP 100000
IDENTITY(INT,1,1) AS N
FROM Master.dbo.SysColumns sc1,
And, yeah... where is the test for BCP?
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs