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

How do you Implement SSIS Packages in your Project?

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

Explain ranking functions?

0 Answers  

---

Which joins are sql server default?

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

What is ms sql server index?

0 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

How to Get the last identity value used

4 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---