Forum Replies Created

Viewing 15 posts - 16,576 through 16,590 (of 59,067 total)

  • 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

  • RE: Recording data changes

    When I've run into such things, I create an audit table that's nearly identical to the original table. I say nearly identical because I create the table with no...

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

    #1907302

  • RE: Please Assist

    compufreak (10/18/2016)

    Hello all,

    okay i have an issue and i am going to seek the help of some experts here...

    basically i created a formula... something like this spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)

    Problem is the "IDs"...

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

    #1907301

  • RE: sql server - how do i get hierarchy of data from two different tables?

    @imanalimi ,

    Since this appears to be for a WBS structure, will you have additional levels than the two that you currently have?

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

    #1907300

  • RE: Business logic

    If you have a lot of calculations that return the same answer and a lot of people calling the same reports and being "this instant up-to-date" just isn't necessary, consider...

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

    #1907299

Viewing 15 posts - 16,576 through 16,590 (of 59,067 total)