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 can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1078

---

Which table keeps the locking information?

984

---

Explain the difference between clustered and non-clustered index?

964

---

What is view in sql?

949

---

What is a partition key?

1028

---

Difference between LEN() and DATALENGTH() in sql server ?

1170

---

What are triggers? How do you invoke a trigger on demand?

1362

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1079

---

What is forward - only cursors / read only cursor?

1129

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

1036

---

Explain unique key in sql server?

1049

---

Do you know what is a linked server in sql server?

1067

---

What is a not null constraint?

1085

---

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

1215

---

Tell me something about security and sql azure?

116

---