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.

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

924

---

What is difference between aggregate and analytic function?

872

---

What is unique key constraint?

987

---

What is Replication?

988

---

How to change parameter value inside the report?

153

---

How to drop an existing user defined function in ms sql server?

979

---

Can you explain important index characteristics?

935

---

What are sql servers used for?

975

---

Define inner join in sql server joins?

986

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

966

---

What is the difference between the application object and session object?

1010

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

892

---

what is raid? : Sql server database administration

968

---

Tell me what is difference between view and materialized view?

881

---

What is the main purpose of having conversation group?

845

---