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
- 5716 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
Can we use pragma autonomous_transaction in trigger?
How to maintain a fill factor in existing indexes?
How to choose all records from the table?
How do you test your database? : sql server database administration
List few advantages of stored procedure.
What is mean by dml?
What is the meaning of sql server?
How to delete multiple rows with one delete statement in ms sql server?
What are the different types of triggers in SQL SERVER?
Can you roll back the ddl statement in a trigger?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
what types of replication are supported in sql server? : Sql server database administration
Why de-normalization required?
What can be used instead of trigger?
Explain how to maintain a fill factor in existing indexes?
