The question I have is WHat if you have some tables that have a With(NOLOCK) hint on them that are joined to tables that do not have the NOLOCK hint on them

i.e. Select *

from title WITH(NOLOCK)

inner join authors on authors.aid = t.aid

This is starting to happen now when some developers are editing existing code - and leaving out the NOLOCK -

We are starting to see some blocking going on and have not yet determined if this is the cause or not.

Thanks.