Answer Posted / Ravi Rao Gautam
Lock hints in SQL Server are clauses used to control how data is locked during query execution. By specifying a lock hint, you can instruct the database engine to use different isolation levels or lock modes, affecting concurrency and performance. Common lock hints include READUNCOMMITTED, READCOMMITTED, REPEATABLE_READ, SERIALIZABLE, UPDLOCK, HOLDLOCK, and TABLOCK.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to have clustered index on separate drive from original table location?
What kind of problems occurs if we do not implement proper locking strategy?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to remove duplicate rows from table except one?
Why use identity in sql server?
What are wait types?
What is subquery? Explain the properties of a subquery?
Does view occupy space?
what is spatial nonclustered index
What is a scheduled job or what is a scheduled task?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the different SQL Server Versions you have worked on?
How raid can influence database performance?
How to enter binary string literals in ms sql server?
