Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7950 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain candidate key, alternate key, and composite key?
How to select an exiting database using mssql_select_db()?
how would you improve etl (extract, transform, load) throughput?
what is datawarehouse?
Are all views updatable ?
Where are full-text indexes stored?
What is index, cluster index and nonclustered index?
1 01 101 01010
What are the tool windows in sql server management studio? : sql server management studio
What is in place upgrade in sql server?
What is the difference between primary key and unique constraints?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the differences between char and nchar in ms sql server?
What is collation?
