i was tracing the activities on our SQL Server to track down some performance issues.
And my attention came to this
SELECT TOP 1 NULL FROM <table> WITH(UPDLOCK)
SELECT TOP (1) * FROM <table> WITH(UPDLOCK) ORDER BY "Entry No_" DESC
The first snippet seems to be from a ISEMPTY
statement while the second snippet is a FINDLAST
. But what makes me wonder is is the WITH(UPDLOCK)
. There is no LOCKTABLE in the code for these tables. Any Ideas what code might caused these SQL statements
We are using NAV 2018 CU38.