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

Can you force a query to use a specific index?

947

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

888

---

What is the importance of three tier architecture?

1093

---

How can we remove orphan records from a table?

986

---

Can you explain what is indexed view? How to create it?

908

---

What is the use of keyword with encryption.

1030

---

How do indexes help, types?

965

---

What are the new features in sql server 2016?

967

---

How to write a query with a full outer join in ms sql server?

1081

---

How to connect sql server management studio express to sql server 2005 express?

1042

---

What is the standby server?

957

---

Can you please explain the difference between primary keys and foreign keys?

1110

---

How many levels of sp nesting are possible?

1028

---

Define clusters?

1083

---

What are the disadvantages of indexes?

1090

---