(Craig Mullins) Since update of a record in one session leads to locking of the page (hence other records that belong to the same page are also locked), what is the workaround so that the application locks only the particular record that is being updated (i.e controlling the locking lower than table
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help