Forum Replies Created

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

  • RE: charindex help

    Borrowing on John's good data creation code and assuming the column is actually a VARCHAR instead of a char, here's a super simple way to take care of double, triple,...

    --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:29 pm

    #1005611

  • RE: Circular logging a T-Log

    Ack... my apologies... Lynn already pointed out the {f1} key. Sorry for the duplication of information.

    --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 6:22 pm

    #1005595

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/5/2009)

    GilaMonster (6/5/2009)

    Lynn Pettis (6/5/2009)

    What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement that...

    --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 3:44 pm

    #1005572

  • RE: Circular logging a T-Log

    To add to what Gail said, "Books Online" or "BOL" is the help system that comes free with SQL Server and can normally be reached just by pressing the {f1}...

    --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 3:38 pm

    #1005567

  • 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

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