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

Answer / sumit

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

Explain powershell included in sql server 2008?

0 Answers  

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

---

---

How do you persist objects, permissions in tempdb

1 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

Tell me extended events in sql server 2008?

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---