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

  • BeerBeerBeer

    Hall of Fame

    Points: 3911

    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

  • SQLGuy64

    Ten Centuries

    Points: 1051

    I know.  weird.

  • Jeff Moden

    SSC Guru

    Points: 994945

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply