Answer / Mohit Madaan

Blocking in SQL Server occurs when one transaction holds a resource (like a table or row) that another transaction needs, causing the second transaction to wait. To troubleshoot blocking, you can use DBCC INPUTBUFFER and DBCC OPENQUERY to identify the blocked queries, SP_WhoIsActive to get detailed information about active sessions, and DBCC BLITZCACHE to check cached query plans.

What is indexing and its types?

1 Answers  

---

Define full outer join?

1 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

1 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What stored by the master? : sql server database administration

1 Answers  

---

what authentication modes does sql server support? : Sql server database administration

1 Answers  

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

What is the difference between left and right outer join?

1 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1 Answers  

---

What is join and name different type of joins?

1 Answers  

---