Forum Discussion

HassanShaddad's avatar
HassanShaddad
Copper Contributor
Nov 20, 2020

Is there any way to make a count select statement without SharedLock on the table

I have a table and I have to count its rows every 10 m  like (SELECT COUNT(ID) FROM dbo.MyTable) the problem that when I count the rows my select put a shared lock on the table and block any insert...

Resources