Forum Replies Created

Viewing 15 posts - 21,796 through 21,810 (of 59,098 total)

  • RE: Please explain what this Trigger query does

    crmitchell (1/19/2015)

    another caveat on no 6.

    Check that you don't have any jobs which disable or worse delete and then later reenable or recreate those triggers.

    If you do then they will...

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

    January 21, 2015 at 10:23 pm

    #1772055

  • RE: SAN Response Times

    burfos (1/21/2015)

    Yes it is an application with separate application servers and it is my least liked system at this site for many many reasons reasons some of which are...

    - 9448...

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

    January 21, 2015 at 7:56 pm

    #1772048

  • RE: SAN Response Times

    Wayne West (1/21/2015)

    I hate to ask this, but is your canned system running an application server? At a prior job we had one that required no stored procedures in...

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

    January 21, 2015 at 7:53 pm

    #1772047

  • RE: Alter table performance

    Charles Kincaid (1/21/2015)

    Understanding the way that SQL Server stores things is very helpful in understanding why some table alterations seem to take no time at all and other will bring...

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

    January 21, 2015 at 7:49 pm

    #1772044

  • RE: Prevent sp_ Procedures with SQLCop

    John Mitchell-245523 (1/21/2015)

    Well off-topic now, but I think I can guess. I use ANSI compliant where it's the only distinguishing feature between two alternatives. For example, CURRENT_TIMESTAMP 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)

    January 21, 2015 at 7:40 pm

    #1772042

  • RE: Prevent sp_ Procedures with SQLCop

    John Mitchell-245523 (1/21/2015)

    Whether anyone thinks it's arrogant or controlling or what have

    I only said it's arrogant to tell someone that you don't know and whose environment and circumstances you don'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)

    January 21, 2015 at 6:42 pm

    #1772040

  • RE: Prevent sp_ Procedures with SQLCop

    RonKyle (1/21/2015)

    Just because you are cleaning up these things doesn't mean Hungarian notation is bad.

    You'll have to pardon me when I say that, IMHO, it's horrible especially when 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)

    January 21, 2015 at 9:27 am

    #1771890

  • RE: Prevent sp_ Procedures with SQLCop

    There's nothing arrogant about it, John. There are many DBAs that simply haven't run into the problems associated with "tbl-ling" and they need to be made aware. Then,...

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

    January 21, 2015 at 8:41 am

    #1771858

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (1/21/2015)

    Jeff Moden (1/21/2015)

    Sioban Krzywicki (1/21/2015)

    I hope everyone here is ok with it too...

    To be honest, I don't care if someone's eyes are on stems and they leave snail...

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

    January 21, 2015 at 8:32 am

    #1771853

  • RE: Backup/restore parition

    GilaMonster (1/21/2015)

    Jeff Moden (1/21/2015)

    GilaMonster (1/21/2015)

    If you're restoring to a new database, the Primary filegroup has to be restored first, then any file/filegroup backups, the the log backups need to be...

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

    January 21, 2015 at 8:31 am

    #1771852

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (1/21/2015)

    I hope everyone here is ok with it too...

    To be honest, I don't care if someone's eyes are on stems and they leave snail tracks. Your contributions...

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

    January 21, 2015 at 8:28 am

    #1771849

  • RE: Backup/restore parition

    GilaMonster (1/21/2015)

    No, not unless the file groups in question are read only.

    To restore a DB from file/filegroup backups, the following is required:

    1) If the DB is in simple recovery, then...

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

    January 21, 2015 at 8:16 am

    #1771839

  • RE: Prevent sp_ Procedures with SQLCop

    John Mitchell-245523 (1/21/2015)

    Jeff

    Yes, I share your distaste for Hungarian notation. But some people swear by it, and if it works for them, who am I to tell them to avoid...

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

    January 21, 2015 at 8:13 am

    #1771836

  • RE: What are First Steps for a dba in new Office?

    Again, this is for what the first things are that need to be done. The most important things are the backups and basic security, as in those things need...

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

    January 21, 2015 at 8:05 am

    #1771827

  • RE: Please explain what this Trigger query does

    Eirikur Eiriksson (1/20/2015)

    Jeff Moden (1/19/2015)

    Eirikur Eiriksson (1/19/2015)

    Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into...

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

    January 21, 2015 at 8:00 am

    #1771822

Viewing 15 posts - 21,796 through 21,810 (of 59,098 total)