Forum Replies Created

Viewing 15 posts - 50,056 through 50,070 (of 59,091 total)

  • RE: Eliminating Cursors

    Kevin Rathgeber (6/13/2008)

    So using more real world scenarios, the while always seems to win out though not by much.

    Jeff, does this seem right to you?

    I'd pretty much agree depending on...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 6:49 pm

    #828858

  • RE: Eliminating Cursors

    Ok... lemme demonstrate a couple of things... first, we need some data that everyone

    can use and we need lot's of it because these tests run so darned fast. ...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 6:14 pm

    #828856

  • RE: Eliminating Cursors

    Well, welcome aboard, Kevin! "Set-based" is nothing more than processing sets of information instead of processing "Row By Agonizing Row" (other wise known as "RBAR"... see my tag line...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 2:46 pm

    #828814

  • RE: Eliminating Cursors

    Outstanding, Kevin! Thanks for posting the code.

    Yep, Matt was right... One test is worth a thousand words... let the "test off" begin. To make it easier for...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 2:24 pm

    #828802

  • RE: Eliminating Cursors

    jcrawf02 (6/13/2008)

    Is a 'test-off' like a 'dance-off'? should I go get some cardboard?

    Only if you want to save the big pieces... 😀

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:53 pm

    #828787

  • RE: Eliminating Cursors

    Matt Miller (6/13/2008)

    Edit: I see Jeff has already thrown the gauntlet:)

    Yep... getting ready to launch some pork chops! 😉

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:47 pm

    #828781

  • RE: Eliminating Cursors

    Kevin Rathgeber (6/13/2008)

    Good point on the SQL 2000 vs SQL 2005. My first attempt was against 2005. I tried again against a sql 2000 database and came out...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:37 pm

    #828772

  • RE: Eliminating Cursors

    Jim Russell (6/13/2008)

    I was getting worried when I got through 5 or 6 pages of this thread and hadn't seen Jeff Moden jumping in to point out that different types...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:35 pm

    #828768

  • RE: Cannot bulk load. Invalid column number in the format file

    sharma (6/13/2008)

    Thanks for ur reply..

    You had changed 1,2,14,37,44 as 1,2,3,4,5

    But it is host file field order only.

    I have to specify sequence order? Because

    i am selecting 1,2,14,37,44 filed from table (file)...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:18 pm

    #828759

  • RE: DELETE DUPLICATE RECORDS

    vinuraj (6/13/2008)

    this link is more than enough...

    ... to bring your server right to it's knee's. It took over 10 minutes to find and delete a lousy 156 rows from...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 1:15 pm

    #828757

  • RE: Remove Locking from particular row

    seenu_61281 (6/13/2008)

    thanks madam..i will try this..

    one more doubt..

    i am using sql 2005 express.i need to insert data from a grid control in vb 6.0. The entries are being done by...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 12:17 pm

    #828721

  • RE: Which syntax is better and why?

    Now, I agree with THAT! That's my favorite format because it puts all of the aliases in the same position horizontally speaking AND it's the same format required by...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 12:07 pm

    #828712

  • RE: Eliminating Cursors

    Bobbie Shrivastav (6/13/2008)

    I was able to utilize the proc. This is GREAT. The only thing I had to change was to use a coalesce rather than isnull....

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 12:01 pm

    #828705

  • RE: Using VBA to pull SQL data into Excel?

    montgomery johnson (6/13/2008)

    I'm using Excel 2003. Do you mean "Import External Data"? Please be more specific. We have many spreadsheets with data imports to more than 10 tabs each. Can...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 10:38 am

    #828658

  • RE: Eliminating Cursors

    dbishop (6/13/2008)

    As a rule, I don't like to use them and try to avoid them as the 'easy way out,' but to say you NEVER use them and you...

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

    Change is inevitable... Change for the better is not.

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

    June 13, 2008 at 10:26 am

    #828653

Viewing 15 posts - 50,056 through 50,070 (of 59,091 total)