Forum Replies Created

Viewing 15 posts - 12,751 through 12,765 (of 59,099 total)

  • RE: No Magical DevOps

    Although certainly related, that is what is known as "SPAM".

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

    March 11, 2018 at 11:14 am

    #1982719

  • RE: Database Restore Failing

    Jeffrey Williams 3188 - Saturday, March 10, 2018 10:02 AM

    Jeff Moden - Friday, March 9, 2018 2:13...

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

    March 11, 2018 at 11:03 am

    #1982718

  • RE: Database Restore Failing

    goher2000 - Friday, March 9, 2018 2:20 PM

    Jeff Moden - Friday, March 9, 2018 2:13 PM

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

    March 9, 2018 at 2:41 pm

    #1982681

  • RE: Database Restore Failing

    jayoub - Thursday, March 8, 2018 11:41 AM

    This morning I rebooted the server and re ran the job and It completed fine
    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)

    March 9, 2018 at 2:15 pm

    #1982676

  • RE: Database Restore Failing

    goher2000 - Friday, March 9, 2018 1:31 PM

    you can probably avoid additional resources used by power-shell by simply mapping the drive 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)

    March 9, 2018 at 2:13 pm

    #1982675

  • RE: Help with Dynamic SQL in Store Procedure

    twin.devil - Friday, March 9, 2018 12:43 AM

    Whole point of creating a dynamic query is to avoid this kind of scenario. So...

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

    March 9, 2018 at 1:43 pm

    #1982672

  • RE: Need a Report Developed

    ak08820 - Friday, March 9, 2018 8:17 AM

    I posted about the status of the job I needed so that others would not...

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

    March 9, 2018 at 10:30 am

    #1982631

  • RE: Need a Report Developed

    ak08820 - Friday, March 9, 2018 4:23 AM

    Hello All

    I am working with someone on this and no longer seeking quotes.

    Thanks

    "Perfect".  That means...

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

    March 9, 2018 at 7:55 am

    #1982610

  • RE: Fill in gaps between 2 dates

    John Mitchell-245523 - Friday, March 9, 2018 2:56 AM

    Jeff Moden - Thursday, March 8, 2018 9:57 PM

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

    March 9, 2018 at 7:15 am

    #1982607

  • RE: Fill in gaps between 2 dates

    jcelko212 32090 - Thursday, March 8, 2018 7:18 AM

    Jeff Moden - Wednesday, March 7, 2018 2:12 PM

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

    March 8, 2018 at 9:57 pm

    #1982575

  • RE: Moving or adding tempdb files best practice

    bwelch42 - Wednesday, March 7, 2018 8:05 AM

    On some database server VMs, I'm seeing regular messages about tempdb data files such as...

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

    March 8, 2018 at 11:38 am

    #1982532

  • RE: What non-database skills should a DBA have?

    nscd - Thursday, March 8, 2018 12:19 AM

    Thanks for all the input everyone. What I've realized reading all this is that 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)

    March 8, 2018 at 10:58 am

    #1982518

  • RE: Index Framentation

    Lj Burrows - Thursday, March 8, 2018 1:56 AM

    here is How to Reduce Fragmentation: http://www.sqlserverlogexplorer.com/how-to-find-database-fragmentation/