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

Does a full backup include transaction log?

960

---

What are user defined functions in ms sql server?

989

---

Define indexes?

1035

---

How will you go about resolving deadlocks?

965

---

Can we add our custom code in ssis?

979

---

What do mean by xml datatype?

1085

---

Tell me what are the essential components of sql server service broker?

936

---

What are secondary xml indexes?

1022

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1043

---

Will sql server 2005 allow you to reduce the size of a column?

981

---

How do I find query history in sql server?

934

---

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

990

---

Can a table have 2 foreign keys?

900

---

How to delete existing rows in a table?

1149

---

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

1036

---