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

Answer / rajkumar

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.

sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.

Answer / harikrishna

Blocks will occur when one processes holds a lock and
second processes requires a conflicting
lock type, then it blocks, check weather the I/O is moving
or not for the blocked processes.
use the below command to know the route block.
select spid,blocked from sysprocesses where blocked>0

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

How many ways to create table-valued functions?

0 Answers  

---

---

What is difference between delete & truncate commands?

0 Answers  

---

What is checkpoint process in the sql server?

0 Answers  

---

Explain about builtinadministrator?

0 Answers  

---

Working with TLogs

0 Answers  

---

What is ems sql management studio? : sql server management studio

0 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

What is data file in computer?

0 Answers  

---