What is blocking in SQL Server? If this situation occurs how
to troubleshoot this issue
- 2 Answers
- 5004 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 do you mean by a dependent functionality in a build?
Define left outer join in sql server joins?
Explain partitioned view?
What is the purpose of grouping data in a report?
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain indexes disadvantages?
Do you know nested transaction?
How to use "begin ... End" statement structures in ms sql server?
Do I need a report server to run reports in my application?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a rownum?
What does top operator do?
What is sharding?
When would you use sql joins?
List some case manipulation functions in sql?
