Answer Posted / saji joseph

Active/Active

Here first node will be default and second node will be
named instance. Both node will be active.

Move group from cluster administration is possible for both
side.

System performance will go down, if both resources are in
one node.

Active/Passive

Only one Active node with default instance.
No system performance degradation will be there for this
case even if we switchover to the other node. Both have
same configuration.

how you can deploy an ssrs report?

185

---

Explain partitioned view?

1128

---

What are the diifferences between the ms sql server vs mysql?

1232

---

What is extent? Types of extents?

1267

---

What is advantage data architect?

972

---

How sql server executes a statement with nested subqueries?

1085

---

How to remove duplicate rows from table except one?

1058

---

what is isolation level at dead lock?

2205

---

How to use clusters?

1008

---

What types of Joins are possible with Sql Server?

1185

---

Write a SQL query to delete a table?

1182

---

Explain different types of index?

1098

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1106

---

How to access the deleted record of an event?

1089

---

What are different replication agents and what's their purpose? : sql server replication

1050

---