rocks (1/9/2013)
So i need to change all my SP's and Views to avoid nolock hint.
By all means, absolutely. If the use of NOLOCK is that pervasive then consider this your opportunity to start living right 🙂
so in this snapshot isolation level no locking happens at all for reporting scripts ( for read only scripts ) how about SP's which runs under transaction.
Locking still occurs such that writers block writers, but in this mode readers are not blocked by writers which is the problem the developers were likely trying to solve by adding all the NOLOCK hints.
Have a read through that article and if you have more questions post back.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato