• Luis Cazares (7/30/2014)


    Don't forget to use NOLOCK hints on all your queries and never ever run DBCC CHECKD, update statistics or rebuild indexes. You might encounter a lot of objects locked during this operations.

    :hehe:

    PS. Just to make it safe for anyone lurking in here, this is just humor.

    Nah... WITH(NOLOCK) is old hat and too much work. Just set the entire server isolation level to "Read Uncommited". :-):-D:-P:hehe:

    To reiterate... "Just to make it safe for anyone lurking in here, this is just humor."

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