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.

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1106

---

List out different types of normalizations in sql server and explain each of them?

929

---

What is a dataset and what are the different types of datasets?

136

---

Does partitioning ssd reduce performance?

894

---

What are the advantages of using cte?

1015

---

What is a View ? Can we insert, Update and delete a view?

995

---

Explain the different types of backups available in sql server? : sql server database administration

925

---

What is the parse query button used for?

1038

---

Where are SQL server users names and passwords are stored in sql server?

1271

---

What is the architecture of ms sql reporting service?

985

---

What is the difference between clustered and a non-clustered index?

1028

---

Can we use where clause in union?

1068

---

How to delete a login name in ms sql server?

1075

---

What is a self join in sql server?

1135

---

What is a join in sql? What are the types of joins?

1107

---