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 is the sql case statement used for? Explain with an example?

1037

---

What is the synonym of join?

1012

---

write an SQL query to list the employees who joined in the month of January?

1734

---

How to create a store procedure with encryption?

1048

---

what are the different stages of Report Processing?

141

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

989

---

Does sql server 2000 full-text search support clustering?

907

---

Explain what are various ways to enhance the ssrs report?

1097

---

What is database replication?

1206

---

What is a filestream?

1043

---

what is unique and xaml nonclustered index

1097

---

Does table partitioning improve performance?

1012

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1447

---

Define primary key?

1193

---

What are the new data types are introduced in sql 2000?

944

---