Answer / wazid ali

Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.

Answer / shyamsri83

When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

What is the xml datatype?

0 Answers  

---

What is a ddl statement?

0 Answers  

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

Why do we partition data?

0 Answers  

---

What is the difference between left and right outer join?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---