Forum Replies Created

Viewing 15 posts - 43,846 through 43,860 (of 59,101 total)

  • RE: SET vs SELECT

    The artical that Paul White pointed us to about the peformance difference between SELECT and SET is pretty close to spot on percentage wise. I'm just not one to...

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

    May 9, 2009 at 7:30 pm

    #991695

  • RE: "tempdb" size -- 550GB!

    Barkingdog (5/9/2009)

    More info:

    1. Temp 550GB was not enough. t-sql job ran into 550GB limit and failed.

    2. Found statement causing the issue. The essence is shown below:

    insert into

    ..

    select distinct ....

    ....

    from

    tableA join...

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

    May 9, 2009 at 6:22 pm

    #991693

  • RE: SET vs SELECT

    Wow... that's a heck of a table. I am so not jealous of either that or the rigors they seem to be putting you through.

    Thanks for the...

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

    May 9, 2009 at 9:55 am

    #991641

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Manie Verster (5/9/2009)

    You only put A-Z and not also a-z. How does that work?

    Peter gave a pretty good description as to why. To simplify, the default for SQL Server...

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

    May 9, 2009 at 9:23 am

    #991630

  • RE: SET vs SELECT

    Florian Reischl (5/9/2009)

    Jeff Moden (5/9/2009)

    BTW - It is good to see growing acceptance of the idea that ANSI standards are kinda 'blah'. I couldn't agree more 🙂

    Man, I agree...

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

    May 9, 2009 at 8:52 am

    #991625

  • RE: SET vs SELECT

    John Esraelo (5/9/2009)

    have not we have had kicked this dead horse plenty..

    I think we did..

    :))

    The bones of these types of dead animals are interesting... its especially interesting to see how...

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

    May 9, 2009 at 7:57 am

    #991621

  • RE: SET vs SELECT

    Paul White (5/9/2009)

    Jeff Moden (5/8/2009)

    Paul White (5/8/2009)

    When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

    Heh... I agree, but where's the code to prove that? ...

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

    May 9, 2009 at 7:53 am

    #991620

  • RE: SET vs SELECT

    Paul White (5/8/2009)

    John,

    When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

    Just adding that for completeness.

    Paul

    Heh... I agree, but where's the code to prove that? ...

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

    May 8, 2009 at 8:00 pm

    #991547

  • RE: SET vs SELECT

    RBarryYoung (5/8/2009)

    *sigh* I'm so misunderstood. 🙁

    Heh... it's the helmet, Barry... can't see your eyes. 😛

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

    May 8, 2009 at 7:58 pm

    #991545

  • RE: SET vs SELECT

    John Esraelo (5/8/2009)

    1> code portability, because of the systems and software shelf-life and change in technology

    I don't believe in the myth of code portability. Consider first that even the...

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

    May 8, 2009 at 7:56 pm

    #991544

  • RE: Matrix multiplication without cursors?

    Yep... the TOP 100 PERCENT thing works just fine although a whole lot of people will tell you

    that order shouldn't matter in most processing. Except for things like...

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

    May 8, 2009 at 7:37 pm

    #991543

  • RE: Just testing the new code window... please disregard

    Yah... you're right... 1 in a row. 😛

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

    May 8, 2009 at 4:52 pm

    #991517

  • RE: Matrix multiplication without cursors?

    PhilM99 (5/8/2009)

    Here are the data as attached files...

    Those files look pretty good. Instead of me trying to weed through this whole post, care to "nut shell" the problem you're...

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

    May 8, 2009 at 3:24 pm

    #991492

  • RE: Just testing the new code window... please disregard

    Just another test... (nothing has changed... all faults still present especially when copy from the forum to QA or SSMS).

    drop table tally

    GO

    --===== Create and populate the Tally table on the...

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

    May 8, 2009 at 3:08 pm

    #991486

  • RE: Matrix multiplication without cursors?

    SELECT TOP 100 PERCENT * FROM --was 3000

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

    May 8, 2009 at 3:03 pm

    #991481

Viewing 15 posts - 43,846 through 43,860 (of 59,101 total)