What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4586 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shyamsri83
When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How do triggers work?
Explain what is log shipping?
A trigger can reference objects outside the current database? State true or false.
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain the difference between function and stored procedure?
Is INSTEAD OF trigger directly applicable to Table ?
What are distributed partitioned views?
How much is a sql server license?
Explain what is the use of custom fields in report?
How to execute a sql statement using mssql_query()?
How to modify an existing stored procedure in ms sql server?
What are the difference between clustered and a non-clustered index?
How many types of triggers in sql server?
