Forum Replies Created

Viewing 15 posts - 43,591 through 43,605 (of 59,097 total)

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/5/2009)

    I won't blame Jeff if some day it stops working, I will just restore the old procedure and tell the users they have to wait 90 minutes for...

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

    June 5, 2009 at 9:25 am

    #1005378

  • RE: Are the posted questions getting worse?

    jcrawf02 (6/5/2009)

    Gianluca Sartori (6/5/2009)

    I don't know if this is a proof, but for sure it is "half a proof".

    Regards,

    Gianluca

    Does that make it a theorem?

    Heh... in theory. 😛

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

    June 5, 2009 at 9:21 am

    #1005371

  • RE: Execute SQL job through batch file

    The use of cmd files to execute sql is a powerful tool that is underutilized...

    I absolutely agree with that. And, old or not, the idea is "there". 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)

    June 5, 2009 at 8:27 am

    #1005313

  • RE: Convert Date

    Bruce W Cassidy (6/4/2009)

    [font="Verdana"]We do have a field named "calendar_date_ddmmyyyy", and I suspect it was created by one of the dodgy consultants we had in who we've been cleaning up...

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

    June 5, 2009 at 7:38 am

    #1005249

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/5/2009)

    Jeff Moden (6/4/2009)

    If you don't trust it, then use a cursor or write a CLR. But, many people have tried to make the "quirky" update go wrong...

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

    June 5, 2009 at 7:33 am

    #1005244

  • RE: Convert Date

    You actually store dates like 1/12/2009 in that format in a calendar table? What do you use those for? I'm asking because I'm curious. I've never seen...

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

    June 4, 2009 at 10:19 pm

    #1005009

  • RE: Convert Date

    Bruce W Cassidy (6/4/2009)

    Jeff Moden (6/4/2009)

    [...]don't store formatted dates in a table... not even a reporting table.

    [font="Verdana"]We could have an argument about that, but in general I believe 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)

    June 4, 2009 at 9:00 pm

    #1004998

  • RE: Convert Date

    To add to what Luke has already stated, do a simple but powerful test that will prove that storing the formatted date in the table is absolutely the wrong thing...

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

    June 4, 2009 at 8:22 pm

    #1004990

  • RE: No More SOX

    Datamama (6/4/2009)

    ... and btw - every great DBA I have ever worked with sounds just like you.

    Josie

    Heh... thanks Josie :blush:. Every good one I've worked with sounds the same...

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

    June 4, 2009 at 7:49 pm

    #1004987

  • RE: How did default definitions change?

    WayneS (6/4/2009)

    Paul, I do believe that you found what was going on.

    Now, I searched the net for hours, and never found any of these articles. How did you do it?

    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)

    June 4, 2009 at 7:21 pm

    #1004979

  • RE: Are the posted questions getting worse?

    Paul White (6/4/2009)

    Jeff Moden (6/4/2009)

    Here's the reason why I use Index(0) instead of Index(1). From BOL:

    Cheers Jeff - it was your motivation in including the hint I was after...

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

    June 4, 2009 at 6:11 pm

    #1004968

  • RE: Are the posted questions getting worse?

    WayneS (6/4/2009)

    Jeff Moden (6/3/2009)

    The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor"...

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

    June 4, 2009 at 6:09 pm

    #1004967

  • RE: Are the posted questions getting worse?

    Oh shoot. I almost forgot. In the absence of all indexes on the Temp Table, the ordered CTE or an ordered Derived Table may appear to work just...

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

    June 4, 2009 at 6:05 pm

    #1004966

  • RE: Are the posted questions getting worse?

    Paul White (6/4/2009)

    The last time I tried this, the 'intermediate materialization' forced a sort as one would expect, but the QO inserted a later sort to ensure updates were performed...

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

    June 4, 2009 at 5:50 pm

    #1004965

  • RE: Are the posted questions getting worse?

    Paul White (6/4/2009)

    Jeff Moden (6/4/2009)

    There was some really cool things I was going to show about the Clustered Index but guess folks will just have to wait for the "book"...

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

    June 4, 2009 at 5:47 pm

    #1004964

Viewing 15 posts - 43,591 through 43,605 (of 59,097 total)