Answer Posted / Prince Bhatia
Blocking in SQL Server refers to a situation where a transaction holds a lock on a resource, preventing other transactions from accessing that resource. This can lead to performance issues as other transactions are forced to wait for the locked resources. Blocking can occur due to long-running transactions, deadlocks, or other factors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I start sql server 2017?
What is sql or structured query language?
What kind of problems occurs if we do not implement proper locking strategy?
Explain “row_number()” in sql server with an example?
What are the source of constraints?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How raid can influence database performance?
What is the difference between for xml raw and for xml auto?
Does view occupy space?
Why we use the openxml clause?
Can sql servers link to other servers like oracle?
How to provide default values to function parameters?
How do I find query history in sql server?
what is the difference between openrowset and openquery?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
