Forum Replies Created

Viewing 15 posts - 50,071 through 50,085 (of 59,102 total)

  • 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

  • RE: Eliminating Cursors

    Chris.Strolia-Davis (6/13/2008)

    while (select count(*) from @table) > 0

    begin

    select top 1 'do something', @id=id from @table

    delete from @table where id=@id

    ...

    --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:22 am

    #828649

  • RE: Eliminating Cursors

    dugsmith (6/13/2008)

    thereby not having to wait for the cursor to be deallocated to release its locks.

    "Firehose" cursors do not keep the same types of locks... in fact, they're pretty much...

    --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:06 am

    #828642

  • RE: Eliminating Cursors

    abhay.kulkarni (6/13/2008)

    Creating a table variable is in the memory, not in the tempdb and hence much more efficient.

    Absolutely NOT true... please see Q4/A4 in the following URL. In fact,...

    --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 9:50 am

    #828633

  • RE: Include Column Headers From SSMS

    Which service pack are you running?

    --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 7:40 am

    #828487

Viewing 15 posts - 50,071 through 50,085 (of 59,102 total)