Hi,Can anybody suggest me reference books or articles(for ground level under standing) that which describes the best with examples on SQL server isolation levels and locking hints.Thanks in advance..
asked
Need reference books or articles for isolation levels and locking hints in SQL Server
There are two good references that will address this that I know of, Kalen Delany's Internals book, and Christian Bolton, Brent Ozar, et al, Internals book.
They'll both cover that topic well.
As an aside, I'm pretty strongly against using locking hints unless you've exhausted every other avenue, and even then using the hint is probably the wrong thing to do.
