Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Zach Nichter » Writing to a File Using the sp_OACreate...

33 posts, Page 4 of 4

«««1 2 3 4

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

Rate Topic

Display Mode

Topic Options

Author

Message

BeerBeerBeer

Posted Wednesday, November 15, 2006 7:40 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239, Visits: 68

255 is usually a significant number in this industry of ours. I wonder where that fits into the issue you just mentioned.

Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Post #323315

Andy Brons

Posted Thursday, November 16, 2006 5:21 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:15 AM
Points: 55, Visits: 188

I know. weird.

Post #323376

Jeff Moden

Posted Saturday, October 20, 2007 7:02 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

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
   INTO dbo.Numbers
   FROM Master.dbo.SysColumns sc1,
        Master.dbo.SysColumns sc2

And, yeah... where is the test for BCP?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #413130

« Prev Topic | Next Topic »

33 posts, Page 4 of 4

«««1 2 3 4

Permissions