Forum Replies Created

Viewing 15 posts - 38,851 through 38,865 (of 59,098 total)

  • RE: Pivoting name value pairs

    COldCoffee (4/19/2010)

    Yes Karthik, i could also see a slight change in the execution plan, but that extra component dint cost the query.. so i guess the query performs equally with...

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

    April 19, 2010 at 9:02 am

    #1153902

  • RE: FizzBuzz

    BTW... the real reason why I'm asking the above question is that it may explain why so many people have questions like "I deleted a table and only have 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)

    April 19, 2010 at 8:55 am

    #1153893

  • RE: Select a string when data in the string varies

    I'll guess I'll have to test the performance of having a separate app handle the file first... it may be the missing link that BCP and BULK INSERT don't have....

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

    April 19, 2010 at 8:27 am

    #1153869

  • RE: FizzBuzz

    Tom.Thomson (4/19/2010)

    Jeff Moden (4/18/2010)

    Right now, I'm testing with the FULL recovery model. I'll follow that up with the SIMPLE model but most folks don't run SIMPLE recovery on databases...

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

    April 19, 2010 at 8:18 am

    #1153865

  • RE: Converting a date

    Nabha (4/18/2010)

    Yes, sorry, completely off the track. I dint know about timestamp clearly. And it looks like its down to 'seconds' that you are suggesting. Thanks Jeff.

    No problem. I...

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

    April 19, 2010 at 12:40 am

    #1153608

  • RE: Converting a date

    Kris-155042 (4/18/2010)

    The data type is bigint and does go down to the seconds. I've run that script and I now get no results.

    Sorry to be such a pain but...

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

    April 19, 2010 at 12:30 am

    #1153606

  • RE: Select a string when data in the string varies

    Or, you can just do it in T-SQL and not have to worry about it 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)

    April 19, 2010 at 12:10 am

    #1153601

  • RE: Pivoting name value pairs

    Absolutely my pleasure. Thanks for the feedback.

    You still might want to read the articles that Lutz pointed out, though. I know the guy that wrote them and he...

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

    April 19, 2010 at 12:07 am

    #1153599

  • RE: Running a SQL Stored Procedure in a Loop

    My recommendation would be to rewrite the proc_student stored proc to use set based code instead of RBAR. However, I do understand that that is sometimes just not...

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

    April 18, 2010 at 11:59 pm

    #1153596

  • RE: Book Recommendation

    Me to... does anyone have a recommendation on this?

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

    April 18, 2010 at 11:42 pm

    #1153593

  • RE: Pivoting name value pairs

    Heh... you know what you get from me when you post tables, readily consumable data, and a nice list of what the results should be?........ A tested, coded answer! ...

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

    April 18, 2010 at 10:50 pm

    #1153580

  • RE: Converting a date

    Nabha (4/15/2010)

    I am guessing,

    wo.COMPLETEDTIME >= Convert(bigint, convert(timestamp, getdate()))

    and ofcourse

    wo.COMPLETEDTIME < Convert(bigint, convert(timestamp, getdate() + 1))

    Ummmm... I know it's just a guess, Nabha, but the TIMESTAMP data type has absolutely...

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

    April 18, 2010 at 10:32 pm

    #1153577

  • RE: The best way to add next month

    lmu92 (4/16/2010)

    The best way to deal with date values is to store it as date values.

    So, instead of having an integer value it woul be a lot better and easier...

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

    April 18, 2010 at 10:12 pm

    #1153573

  • RE: define composite primary key with more than 900 bytes

    I still can't believe that someone needs a 70 column primary key. Without actually understanding the table at hand, I believe that some normalization would be in order. 😉

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

    April 18, 2010 at 10:00 pm

    #1153571

  • RE: dateDiff question

    SQL_NuB (4/14/2010)

    OK, I've been looking online and reading many articles on how to exclude weekends, however, most of the articles are assuming that your start date or end date begin...

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

    April 18, 2010 at 9:57 pm

    #1153568

Viewing 15 posts - 38,851 through 38,865 (of 59,098 total)