Using UPDLOCK and HOLDLOCK to prevent duplicate data from being inserted
I have a service method (C#) that retrieves data from an Azure SQL Server Database, process it and then performs some inserts. When this method is called from different processes, for a large number of data, I sometimes get duplicate records, same data being inserted.