Hi Sir,
I've facing like your problem, I know the transaction was locking table by default. So, I'll use with no lock for speed up reading on your web app. Lets we discuss for details.
Regards
Lucky
Relevant Skills and Experience
I'm fullstack developer with expertise in .Net, SQL, WebApp, Desktop and ERP SAP. And as solution architect in various projects.