what is the use of : WITH (NOLOCK, READUNCOMMITTED)

  • GSquared (11/17/2011)


    Oh trust me, I've had my goof-up posts. Gail and Paul are the ones who catch me on it now and again. Those two are a good safety net.

    I'd bet that Gail has to tech edit at least 1% of my posts. Which is quite a few more than I care to admit!

    That being said, I usully don't make the same error again, ever.

  • It's got nothing to do with a difference of opinion.

    It's got to do with someone who was posting blatantly incorrect advice (advising people to detach suspect databases, to delete transaction logs, etc) and who would never admit he was wrong.

    One time I called him on a particularly bad error and his reply was along the lines of 'What would someone doesn't hold any certifications know?'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • This guy was the perfect <shit> storm of bad mannerism and even worst advice with a <avalanche> hint of God complex.

    That sums it up pretty good :-D.

  • Ninja's_RGR'us (11/17/2011)


    This guy was the perfect <shit> storm of bad mannerism and even worst advice with a <avalanche> hint of God complex.

    That sums it up pretty good :-D.

    And as I hit post, Walk on Water starts playing! 😀

  • GilaMonster (11/17/2011)


    It's got nothing to do with a difference of opinion.

    It's got to do with someone who was posting blatantly incorrect advice (advising people to detach suspect databases, to delete transaction logs, etc) and who would never admit he was wrong.

    One time I called him on a particularly bad error and his reply was along the lines of 'What would someone doesn't hold any certifications know?'

    This guy seem to be popular. Everyone knows him. 😀

    The example you quoted was really worst. Feeling pity for him. Such a sick mentality. 🙁

  • Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

    Jared

    Jared
    CE - Microsoft

  • p-nut (11/17/2011)


    Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

    Jared

    All of us are bots. Aren't you?

    Edit: But really, I heard a rumor that Bill Gates will pay by the word for every post we put on the Internet, with a percentage of it going to our favorite charities. Didn't you know that? Why do you think I'm so long-winded in my posts?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • GSquared (11/17/2011)


    p-nut (11/17/2011)


    Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

    Jared

    All of us are bots. Aren't you?

    All your bots are belong to us.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (11/17/2011)


    GSquared (11/17/2011)


    p-nut (11/17/2011)


    Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂

    Jared

    All of us are bots. Aren't you?

    All your bots are belong to us.

    Johnny 5 ALIVE!

    Seriously though... I mean, seriously...

    Jared
    CE - Microsoft

Viewing 9 posts - 46 through 53 (of 53 total)

You must be logged in to reply to this topic. Login to reply