Answer Posted / suman j

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 do I run a trace in sql server?

929

---

What are null values in ms sql server?

1022

---

What according to you is the difference between mysql and sql server performance?

1021

---

How can we delete Duplicate row in table?

999

---

What is the difference between a check constraint and a rule?

1131

---

How to test values returned by a subquery with the in operator?

1133

---

What is a rownum?

893

---

What is the difference between getdate and sysdatetime?

941

---

Would you store your query in a ssrs report or a database server? State the reason why?

148

---

What is the difference between local and global temporary tables?

1075

---

What are the fixed server level roles? : sql server security

1052

---

What is the difference between upgrade and migration in sql server?

1024

---

Why is sql server log file full?

977

---

How to find Duplicate Records In table?

959

---

what is datawarehouse?

1053

---