Forum Replies Created

Viewing 15 posts - 47,791 through 47,805 (of 59,095 total)

  • RE: Returning all rows with Split function

    If you want to return a table's worth of splits, then you have to stop worrying about the rows and worry only about the column. 😀

    I don't know...

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

    October 11, 2008 at 7:55 pm

    #883840

  • RE: Primary Key

    And I disagree because RI isn't the only reason to have a PK. 😉

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

    October 11, 2008 at 3:32 pm

    #883827

  • RE: Primary Key

    Heh... and by the way... this...

    T - you do whatever transformation or massaging is needed...

    ... sometimes means deleting duplicated data. 😉

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

    October 11, 2008 at 2:54 pm

    #883810

  • RE: Primary Key

    PaulB (10/11/2008)

    A delete on a staging table is like saying "I don't care about this row coming from the source application", if that actually happens either the Data Warehouse is...

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

    October 11, 2008 at 2:51 pm

    #883809

  • RE: Midnight Date Function

    GilaMonster (10/11/2008)

    Jeff Moden (10/11/2008)

    ... and, here's the tests... these work on both 2k and 2k5. According to Gail's fine blog, some of these tests will not work on 2k8...

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

    October 11, 2008 at 2:42 pm

    #883806

  • RE: Exclude Word List to filter SELECT results

    rbarryyoung (10/10/2008)

    Tomm: That doesn't do the same thing. Note that if some EXCLUDEs match a LOCATION row and some do not, then it will return one or more...

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

    October 11, 2008 at 2:25 pm

    #883804

  • RE: Primary Key

    PaulB (10/11/2008)

    I love you too guys but not every table need to have a PK.

    How about staging tables in a Data Warehouse environment?

    As you should know Staging tables are nothing...

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

    October 11, 2008 at 11:58 am

    #883783

  • RE: Delete Duplicate values

    Outstanding explanation, Kenney.

    On the recursive thing... do keep in mind that recurssion is nothing more than a loop and has the same performance impedements as a loop. In other...

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

    October 11, 2008 at 11:33 am

    #883780

  • RE: Table Variables and performance

    Except for things like what Marios pointed out, I avoid table variables like the plague not only because of their "single record" execution plan, but because they are also more...

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

    October 11, 2008 at 11:20 am

    #883778

  • RE: Midnight Date Function

    Guess I'll throw the testing I've done in the past into the ring... 🙂

    The testing below takes the "display" out of the picture using a throw-away variable of the DATETIME...

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

    October 11, 2008 at 11:11 am

    #883777

  • RE: Midnight Date Function

    Chris Harshman (10/10/2008)

    Gary Johnson (10/10/2008)

    It would be interesting to see what performed better. 😉

    Actually the DateAdd/DateDiff method seems to perform slightly better (like 6 milliseconds better over 25,000 rows) than...

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

    October 11, 2008 at 10:09 am

    #883774

  • RE: 'N' number of usage - Tally Table

    ggraber (10/10/2008)

    Nope, I'm not 100% sure I know what you mean by a "Tally CTE." Sounds like you're gonna create a tally table on the fly. Which sounds pretty...

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

    October 10, 2008 at 7:43 pm

    #883712

  • RE: 'N' number of usage - Tally Table

    rbarryyoung (10/10/2008)

    And what bothers me most about this is that I know that it is not the extra formatting that is killing my speed, but the built-in formatting that 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.

    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)

    October 10, 2008 at 7:36 pm

    #883711

  • RE: 'N' number of usage - Tally Table

    J (10/10/2008)

    "Thorn"

    wut?

    "Thorn" is actually the name of a character in the ASCII character set. A good description and history of the character is found at the following URL...

    http://en.wikipedia.org/wiki/%C3%9E

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

    October 10, 2008 at 7:31 pm

    #883710

  • RE: Creating Functions for Stored Procedures

    Alex Grinberg (10/10/2008)

    You could use select * from sys.objects where is_ms_shipped = 0 as well. I am not INFORMATION_SCHEMA fan. This is personal preference.:D

    Heh... I forgot about that. I'm...

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

    October 10, 2008 at 7:24 pm

    #883708

Viewing 15 posts - 47,791 through 47,805 (of 59,095 total)