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.

Why functions are used in sql server?

898

---

What is the maximum size per database for sql server express?

975

---

Why do we partition data?

979

---

Where can you add custom error messages to sql server?

1055

---

What is a filestream?

945

---

What is the purpose of the master database?

1053

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1042

---

How do I port a number to sql server?

983

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

943

---

Does table partitioning improve performance?

905

---

What are the differences between clustered and non-clustered index?

956

---

What happens if date-only values are provided as date and time literals?

978

---

What are information schema views?

924

---

Differentiate between a having clause and a where clause.

928

---

Can you get second highest salary from the table?

913

---