Forum Replies Created

Viewing 15 posts - 19,636 through 19,650 (of 59,098 total)

  • 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

  • RE: Find string with spaces and replace them with other string

    shamshad.ali (9/8/2015)

    I have following query which return me SP/Views and Functions script using:

    select DEFINITION FROM .SYS.SQL_MODULES

    Now, the result looks like

    Create proc

    create procedure

    create proc

    create ...

    --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:15 am

    #1825083

  • RE: Need help on excel file generation through backend

    Kind of. As you've found out, BCP is not actually capable of exporting "Excel" files. It's only capable of exporting text (and data formatted specifically for SQL Server)...

    --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:44 am

    #1825078

  • RE: The Scientific Method

    jhbelalc (9/8/2015)

    Now, software works or not, yes that easy.

    If that were only true.

    --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:34 am

    #1825076

  • RE: ISNULL vs IS NULL performance

    "It Depends". By themselves, everything above is true. However, if you have sufficient other predicates against the table, you CAN still get index seeks from those predicates even...

    --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 7, 2015 at 11:03 pm

    #1825036

Viewing 15 posts - 19,636 through 19,650 (of 59,098 total)