Forum Replies Created

Viewing 15 posts - 19,606 through 19,620 (of 59,072 total)

  • RE: matainence jobs are failing

    Thanks for the feedback... I hate problems like that because you never know when they'll occur 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)

    September 9, 2015 at 5:05 pm

    #1825565

  • RE: JSON

    Manic Star (9/9/2015)

    JSON is evil incarnate. XML's bastard sibling at best.

    😀

    I LOVE IT! A kindred spirit!!!! 🙂

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

    September 9, 2015 at 5:04 pm

    #1825564

  • RE: Delete large number of records

    I have to agree with Scott on this one. This table is actually fairly small and, because of the monthly rolloff, isn't going to get much bigger quickly. ...

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

    September 9, 2015 at 5:00 pm

    #1825563

  • RE: Trigger fire on each inserted row to insert same record into remote Table

    It's a REALLY bad idea to make INSERTs dependent on the availability of a remote server. Your trigger should write to a "local" table and you should 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)

    September 9, 2015 at 3:48 pm

    #1825557

  • RE: matainence jobs are failing

    coolchaitu (9/9/2015)

    It ran successfully today. Thanks everyone

    What changed? Or did you resave 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)

    September 9, 2015 at 11:07 am

    #1825486

  • RE: Point in time recovery

    jitendra.padhiyar (9/9/2015)

    Hello Masters,

    We got request from our client to have point in time restore.

    Full Backup: Everyday at 2 AM.

    Log backup Everyday 2 PM

    Now client wants us the data upto...

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

    September 9, 2015 at 7:43 am

    #1825397

  • RE: Delete large number of records

    oneteabag (9/8/2015)

    Good Point Jeff.

    Reason is the process is happening so fast within couple of hours and with every iteration actual production reports are executed and checked until an 'ok'...

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

    September 8, 2015 at 5:30 pm

    #1825302

  • RE: Delete large number of records

    oneteabag (9/8/2015)

    [font="Arial Black"]A New Monthly data is being loaded, checked and finally approved after 6 or 7 iteration before approval.

    [/font]Because of this iteration the monthly data set is being added...

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

    September 8, 2015 at 4:35 pm

    #1825298

  • RE: First Occurance of the string from text

    sgmunson (9/8/2015)

    Jeff,

    The original poster's rules, no matter how they were stated, across ALL of his/her posts, are broken based on the data supplied and the expected results. 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)

    September 8, 2015 at 4:23 pm

    #1825294

  • RE: The Scientific Method

    chrisn-585491 (9/8/2015)

    This sounds like a good way to actually build a piece of software.

    Software isn't science, it's engineering. (And a lot of it is Redneck Engineering...) 😛

    Usually, it's...

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

    September 8, 2015 at 4:08 pm

    #1825288

  • RE: The Scientific Method

    jhbelalc (9/8/2015)

    Jeff Moden (9/8/2015)

    Jeff Moden (9/8/2015)That's a large part of the problem. Poorly defined jobs and obstinacy (and a few other "anti-traits"). Add all that to some ridiculous...

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

    September 8, 2015 at 3:35 pm

    #1825283

  • RE: The Scientific Method

    jhbelalc (9/8/2015)

    Jeff Moden (9/8/2015)

    I'll say that a lot of developers aren't actually qualified to determine what the client's expectations are. That's why there's such a thing as "requirements" 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)

    September 8, 2015 at 8:02 am

    #1825143

  • RE: matainence jobs are failing

    Just a hunch... I've not had such thing happen to me for maintenance plans because I don't use them. However, if I did, the first thing I'd try 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)

    September 8, 2015 at 7:54 am

    #1825137

  • RE: The Scientific Method

    jhbelalc (9/8/2015)

    the boundaries are 'properly filled' only if the client say so.

    The person in charge of deliver the software to the client can say it's finished but finally only the...

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

    September 8, 2015 at 7:33 am

    #1825125

  • RE: Finding numeric and alpha vs just alpha data query

    karen.blake (9/7/2015)

    Hi All,

    Will try and explain this better.

    We have a SAL field in the database that has numeric and alpha and just alpha data in it.

    I need to get 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)

    September 8, 2015 at 6:48 am

    #1825097

Viewing 15 posts - 19,606 through 19,620 (of 59,072 total)