sqlserver 2008 Isolation question

Posted on 2011-05-11
Last Modified: 2012-06-21

I am using isolation level at database level as read committed snapshot however i am using no lock hint at statement level.which one will overide first? one more thing is i would like to change read commited snapshot to default isolation at database to do it?
Question by:chandradineshbabu
    LVL 39

    Expert Comment

    Here's how to change it at DB level:

    As far as swithcing back and use NOLOCK hint I suggest you read the article below before deciding to go that way to see and understand what NOLOCK means and does:
    LVL 9

    Accepted Solution

    There will be no effect with nolock hint with snapshot isolation level. Because snapshot isolation level holds no locks on the underlying table. Instead it uses row versioning to handle the concurrency.


    Author Comment

    my question is i have a database with read commited snapshot isolation level  however the databse is hitting with a qurey with No Lock Hint.which will override(reading data from tempdb due to read commited snap shot or dirty reads due to No Lock Hint)?

    Author Closing Comment

    Excellent Really helpfull to me

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now