Forum Replies Created

Viewing 15 posts - 39,661 through 39,675 (of 59,098 total)

  • RE: t-sql SUM

    erdem1973 (2/25/2010)

    Thank you very much for your replies.

    I have solved the issue with your help..

    Would you post your final code, please?

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

    February 25, 2010 at 6:20 am

    #1124903

  • RE: FizzBuzz

    By the way... I took a look at most of the code in the contest you have going on... all you folks that are converting the number to VARCHAR() 6,...

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

    February 25, 2010 at 12:26 am

    #1124773

  • RE: FizzBuzz

    reidres (2/24/2010)

    OK, I have run all four of the ones that are scalable/credible contenders and I have, for 150 000 000 rows using the COUNT (ALL xxxx) method described earlier....

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

    February 24, 2010 at 11:05 pm

    #1124759

  • RE: FizzBuzz

    Jeff Moden (2/24/2010)

    Manie Verster (2/23/2010)

    Jeff, I forgot some points in my previous post to you. To hardcode a query is never good and there you have me. It looks 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)

    February 24, 2010 at 10:41 pm

    #1124756

  • RE: Setting Fill Factor on Database or Entire SQL Instance

    aflores1-976495 (2/23/2010)

    I have been asked by our Software Vendor to set the Fill Factor to 75% for their entire database. (their database is the only one that resides the server)

    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)

    February 24, 2010 at 10:10 am

    #1124373

  • RE: Problems with Date Searches

    thomas.hill (2/23/2010)

    Wayne,

    I tried what you sent me and ran into just a small problem... but I think I fixed it...

    Here's what you sent: WHERE DateEnd >= '1/1/2009'...

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

    February 24, 2010 at 6:29 am

    #1124229

  • RE: Create table dynamically using loop

    I agree with the others... IF you have the Enterprise edition, then partitioned tables would probably be the way to go.

    If you don't have the Enterprise edition, then the separate...

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

    February 24, 2010 at 6:25 am

    #1124227

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    One point in all this that you are missing is that when a person is in an interview, no matter how tough you are, you are nervous 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)

    February 24, 2010 at 6:13 am

    #1124223

  • RE: FizzBuzz

    CirquedeSQLeil (2/23/2010)

    Manie Verster (2/23/2010)

    CirquedeSQLeil (2/23/2010)

    Manie Verster (2/23/2010)

    One point in all this that you are missing is that when a person is in an interview, no matter how tough you are,...

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

    February 24, 2010 at 5:45 am

    #1124215

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    Jeff, I forgot some points in my previous post to you. To hardcode a query is never good and there you have me. It looks like I am...

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

    February 24, 2010 at 5:41 am

    #1124213

  • RE: Help- Very Complex SQL query

    Paul White (2/23/2010)

    @jeff:

    The reason I didn't do it here is because I tried to convert the 2005 updatable CTE as faithfully and obviously as possible. So, the CTE just became...

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

    February 23, 2010 at 7:27 pm

    #1124037

  • RE: Help- Very Complex SQL query

    mister.magoo (2/23/2010)

    For those interested, here's the proper way to write the code following "my" best practices...

    UPDATE dbo.TableA

    SET SomeColumn = b.SomeOtherColumn

    FROM dbo.TableA ...

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

    February 23, 2010 at 7:25 pm

    #1124035

  • RE: FizzBuzz

    That certainly works and it's a whole lot better than a WHILE loop. It certainly shows that you have more than just a casual knowledge (as previous similar examples...

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

    February 23, 2010 at 7:14 pm

    #1124029

  • RE: Help- Very Complex SQL query

    Jeff Moden (2/23/2010)

    Paul White (2/22/2010)

    Jeff Moden (2/22/2010)

    I guess I didn't understand that one... it sets all the rows to 50 instead of doing the requested data smear.

    It works on...

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

    February 23, 2010 at 5:38 pm

    #1124001

  • RE: Help- Very Complex SQL query

    WayneS (2/22/2010)

    Paul White (2/22/2010)

    WayneS (2/22/2010)

    I must have missed the updated requirements... let me look at what those are and see what I can do.

    The updated test data setup script 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)

    February 23, 2010 at 4:50 pm

    #1123983

Viewing 15 posts - 39,661 through 39,675 (of 59,098 total)