Answer / Prince Bhatia

Blocking in SQL Server refers to a situation where a transaction holds a lock on a resource, preventing other transactions from accessing that resource. This can lead to performance issues as other transactions are forced to wait for the locked resources. Blocking can occur due to long-running transactions, deadlocks, or other factors.

What is the query and subquery?

1 Answers  

---

What do you mean by stored techniques? How would we use it?

1 Answers  

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

Detail about query optimizer?

1 Answers  

---

What is fill factor and pad index?

1 Answers  

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

1 Answers  

---

Differentiate between delete and truncate.

1 Answers  

---

What are trace flags?

1 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

What is transaction server isolation?

1 Answers  

---

How do I schedule a sql server profiler trace?

1 Answers  

---