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
- 5717 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
Write an sql query to find first weekday of the month?
Explain how to use linked server?
What can be used instead of trigger?
What is the temp table?
How to create a stored procedure with a statement block in ms sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Explain the functionalities that views support?
What new data source types were added in ssrs 2014?
What is the server name for sql management studio?
What are the types of joins in sql?
How to add an address record into adventureworkslt?
What is sql server programming?
Can a database be shrunk with users active?
How to create an index on a view?
What is a trace frag?
