Forum Replies Created

Viewing 15 posts - 47,011 through 47,025 (of 59,095 total)

  • RE: Advice for array oflarge arrays

    It sure does... let's have a race when we're done... CLR vs T-SQL.

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

    November 25, 2008 at 6:59 pm

    #903504

  • RE: Missing Indexes in SQL Server 2005

    Wayne West (10/22/2008)

    Thanks for the article, Ranga, very useful. I look forward to getting our ERP system into 2005 or 2008 as I know they're not doing a good...

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

    November 25, 2008 at 6:43 pm

    #903501

  • RE: The Numbers Table

    thisisfutile (11/25/2008)

    Thanks for the professional approach in your response.

    You just made my day. Thanks for taking it the right way and thanks for the nice compliment!

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

    November 25, 2008 at 5:55 pm

    #903497

  • RE: Knowledge sharing

    Manie Verster (11/25/2008)

    I was talking about rookies/newbies that are really struggling to do it and in the workplace you don't get a lot of people that wants to help and...

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

    November 25, 2008 at 6:52 am

    #903100

  • RE: want only date portion from datetime datatype in UPDATE statement

    Yep... the DATEADD function will help in those areas. Check out Books Online for the syntax and parts of the date you can modify.

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

    November 25, 2008 at 6:41 am

    #903084

  • RE: Exercise to practise SQL

    Yep... that's a totally useful post and link. Glad you were on it.

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

    November 25, 2008 at 6:39 am

    #903081

  • RE: Knowledge sharing

    I don't have a problem either helping rookies or being patient with them. I do have a problem with people that have a gazillion titles after their name and...

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

    November 25, 2008 at 12:05 am

    #902946

  • RE: Conditional Where

    jcrawf02 (11/24/2008)

    "jeffIsAGiantGoober" ??? Heh... I guess that's better than some of the things I have been called... 😛

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

    November 24, 2008 at 11:51 pm

    #902937

  • RE: Advice for array oflarge arrays

    Ok... I've got the split done. I just need to "smear" the Group number, SubGroup number, and a couple of other things throughout the "matrix". Since this isn't...

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

    November 24, 2008 at 10:33 pm

    #902895

  • RE: Calculate values from previous records in a series

    Thanks, ehlinger ... I appreciate the detail. Just wanted to make sure you were "covered". Good "seeing" you again.

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

    November 24, 2008 at 9:15 pm

    #902868

  • RE: Function that finds Sundays

    Michael Valentine Jones (11/24/2008)

    Michael Valentine Jones (11/21/2008)

    marty.seed (11/21/2008)

    Sorry, good question. The next Sunday

    So if I was to pass in todays date I would get 11/23/08

    What do you want it 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)

    November 24, 2008 at 9:11 pm

    #902866

  • RE: The Numbers Table

    GOC (11/24/2008)

    I must be missing something here. The thing I don't get about the whole tally of numbers discussion is why so much time and effort seems to always be...

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

    November 24, 2008 at 8:40 pm

    #902859

  • RE: The Numbers Table

    jacroberts (11/24/2008)

    timothyawiseman (11/24/2008)

    jacroberts (11/24/2008)

    Performance isn't always an issue as in my previous example.

    I agree with Jeff that performance should always be a concern. After all, you may eventually need...

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

    November 24, 2008 at 8:23 pm

    #902856

  • RE: The Numbers Table

    thisisfutile (11/24/2008)

    Jeff Moden (11/24/2008)

    jacroberts (11/24/2008)

    ... queried the table with 4000 rows in in less than 1 second.

    That's pretty slow and performance should be always an issue...

    With all due respect Jeff,...

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

    November 24, 2008 at 7:41 pm

    #902850

  • RE: The Numbers Table

    Adam Machanic (11/24/2008)

    I'll add that recursion isn't much better than a While loop and is sometimes worse.

    I beg to differ. Recursion (in T-SQL) is always worse than a...

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

    November 24, 2008 at 6:59 pm

    #902845

Viewing 15 posts - 47,011 through 47,025 (of 59,095 total)