What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 4563 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 is triggers in ms sql server?
Name 3 ways to get an accurate count of the number of records in a table?
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?
Can you explain powershell included in sql server 2008?
What is delete query?
What is a non equi join?
What are various aggregate functions that are available?
Where is trigger in sql server?
what purpose does the model database serve? : Sql server database administration
When we should use @@error?
What do you mean by sql server agent?
Can I disable or restrict ssrs export formats (rendering formats)?
Explain atomicity?
What is SubQuery in SQL Server 2008
What is a full text index?
