Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 5620 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / wazid ali
Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How raid can influence database performance?
What is database dimension? : sql server analysis services, ssas
Can a rule be bound to any column of any data type?
What is xdr?
What happens if null values are involved in string operations?
What is difference between count (*) and count column?
Should you normalize audio?
Detail about query optimizer?
List the ways in which dynamic sql can be executed?
How to resolve the orphan use problem? : sql server security
What is the parse query button used for?
What do you understand by integration services in sql server?
What are the types of database recovery models?
Explain temporary table vs table variable by using cursor alternative?
What is subreport?
