Forum Replies Created

Viewing 15 posts - 16,606 through 16,620 (of 59,101 total)

  • RE: sql backup

    Brandie Tarvin (10/20/2016)

    Jeff Moden (10/19/2016)

    Steve Jones - SSC Editor (10/19/2016)

    Jeff Moden (10/18/2016)

    Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3...

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

    October 20, 2016 at 7:26 am

    #1907643

  • RE: sql backup

    Steve Jones - SSC Editor (10/19/2016)

    Jeff Moden (10/18/2016)

    Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to Network Attached...

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

    October 19, 2016 at 5:52 pm

    #1907557

  • RE: Archaic Commands

    chrisn-585491 (10/19/2016)

    I personally don't like complex tasks that require many steps in GUI application. [font="Arial Black"]It's probably why I don't care for much of SSIS quirks.[/font] Or the fact 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)

    October 19, 2016 at 8:25 am

    #1907426

  • RE: Deleted

    Eric M Russell (10/19/2016)

    Jeff Moden (10/18/2016)

    Just to throw my opinion into the ring...

    I've been tremendously successful and I barely know how to spell SSIS, SSDT, SSAS, SSRS, or any of...

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

    October 19, 2016 at 8:02 am

    #1907422

  • RE: Restore database

    Deny Christian (10/18/2016)

    Jeff Moden (10/18/2016)

    Deny Christian (10/18/2016)

    I still confuse about Restoring:

    Specify the source and location of backup sets to restore:

    from database

    from device

    what's the different ?

    FROM DATABASE is typically used only...

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

    October 19, 2016 at 12:49 am

    #1907331

  • RE: Restore database

    Deny Christian (10/18/2016)

    I still confuse about Restoring:

    Specify the source and location of backup sets to restore:

    from database

    from device

    what's the different ?

    FROM DATABASE is typically used only when you want to...

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

    October 18, 2016 at 11:37 pm

    #1907321

  • RE: Recording data changes

    Bruce-12445 (10/18/2016)

    I have written triggers a long time ago so I'll give it a go and it all should come rushing back in.

    Correct me if I'm wrong: I'll 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)

    October 18, 2016 at 11:33 pm

    #1907320

  • RE: update trigger get fields before and after update

    Eirikur Eiriksson (10/13/2016)

    Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.

    Correct me if I'm wrong, please. It would...

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

    October 18, 2016 at 11:29 pm

    #1907319

  • RE: update trigger get fields before and after update

    @Patrick123 (10/14/2016)

    thanks

    I see that you've marked the checksum method as your choice. Please, see my warning about the checksum method a little further up in this discussion.

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

    October 18, 2016 at 11:23 pm

    #1907318

  • RE: update trigger get fields before and after update

    CELKO (10/13/2016)

    Have you considered getting a third party audit tool? Why reinvent the wheel, expose yourself to legal problems, and slow your overall performance?

    I've found that most 3rd party audit...

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

    October 18, 2016 at 11:21 pm

    #1907316

  • RE: permission for execel to connect to SQL server

    Create a stored procedure to return what they want. Give them privs to run the stored procedure and have the stored procedure execute as owner. That way, you...

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

    October 18, 2016 at 9:10 pm

    #1907311

  • RE: finding the current ID value compared to the IDENTITY value

    PearlJammer1 (10/18/2016)

    Hi Jeff

    As ever, your thoughts are greatly appreciated so thanks for your input on this. I have posted the script that I finally used to return what 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)

    October 18, 2016 at 8:47 pm

    #1907310

  • RE: Restore database

    Deny Christian (10/18/2016)

    jasona.work (10/17/2016)

    homebrew01 (10/17/2016)

    andrew gothard (10/17/2016)

    Firstly, if you do your backup with the checksum option, this will identify various forms of potential corruption. Restore with verifyonly will also...

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

    October 18, 2016 at 8:00 pm

    #1907307

  • RE: Recording data changes

    Bruce-12445 (10/18/2016)

    thanks, that looks good. is the delete table specific to each table. I'm thinking I might get away with putting the trigger directly on the apps table which shouldn't...

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

    October 18, 2016 at 7:42 pm

    #1907305

  • RE: Deleted

    Just to throw my opinion into the ring...

    I've been tremendously successful and I barely know how to spell SSIS, SSDT, SSAS, SSRS, or any of the other 4 letter words...

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

    October 18, 2016 at 7:28 pm

    #1907303

Viewing 15 posts - 16,606 through 16,620 (of 59,101 total)