Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7897 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
Define constraints and give an example of their use?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is a with(nolock)?
What are logical database components? : SQL Server Architecture
How to perform backup for certificates in sql server? : sql server security
How do I determine how many instances of sql server are installed on a computer?
What is query and its types?
what is the information that can be stored inside a bit column? : Sql server database administration
What is always encrypted?
What is the use of floor function in sql server?
Define indexes?
Explain log shipping and mention its advantages.
How to handle error or exception in sql?
How to provide values to stored procedure parameters in ms sql server?
Difference between LEN() and DATALENGTH() in sql server ?
