Avoiding locks in tables

Using the 'nolock' clause we are avoiding create collisions or jam
if in that moment another task is updating the same table


update tblTable
set sinStepCodeId = 2
from tblTable
where sinStatusid in(2)

go

Select count(*) from tblTable nolock

go
...