Answer Posted / mamatha

A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime.

What are the different types of sub-queries?

1009

---

What is index fragmentation in ms sql server?

1035

---

How to install sql server 2005 express edition?

1068

---

What is tablix?

156

---

How to list all columns in a table using odbc_columns()?

943

---

How to use transact-sql statements to access the database engine?

1014

---

What is transaction server isolation?

980

---

What is the command used to check locks in microsoft sql server?

987

---

What is the difference between clustered and a non-clustered index?

992

---

What is compound operators?

991

---

What do you mean by cardinality?

860

---

Explain how dts is used to extract, transform and consolidate data?

955

---

What does asynchronous call backs means?

1089

---

What are the advantages of having an index on the sql server?

883

---

What are null values in ms sql server?

1037

---