Answer / wazid ali

Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.

Answer / 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.

When would you use the stored procedures or functions?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

how can do you the system monitoring?

1 Answers  

---

What is proper subset of candidate key?

0 Answers  

---

---

Why main is user defined function?

0 Answers  

---

What is normalization process?

0 Answers  

---

What is a trigger?

7 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

What is difference between group by and having?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---