SELECT * FROM TABLENAME WITH (NOLOCK)
INSERT INTO TABLENAME WITH (ROWLOCK)
UPDATE TABLENAME WITH (ROWLOCK)
Use "Nolock" in select query and in transaction query use "RowLock". and Use Stored Procedure Instead of using view/direct fetching data from sql query.