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

How can we get count of the number of records in a table?

951

---

whats the maximum size of view state??

2188

---

What is normalization? What number of normalization shapes are there?

1104

---

How much memory that we are using in Logshipping Concept?

1783

---

How will you decide the active and passive nodes?

1125

---

What is triggers in ms sql server?

1113

---

What is default port number for sql server 2000?

1040

---

What are the disadvantages of merge replication?

1410

---

Can you name some of the dml commands in sql?

1022

---

what are different types of backups available in sql server? : Sql server database administration

931

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

981

---

Does sql server 2000 clustering support load balancing?

966

---

Create and insert into temp table in sql server?

1020

---

What is store procedure?

1056

---

What are the different types of locks in the database?

919

---