• I have seen saying that using NOLOCK is good sign of the poor design.

    In my current work, we use NOLOCK in all SQL statements, (I know its not good)

    from the given scenario can anyone advice is there a way to bypass the NOLOCK usage and still get the same performance?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.