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

What is exporting and importing utility?

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

Explain filestream storage of sql server 2008?

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

What is collation sensitivity? Explain different types.

0 Answers  

---

What is key set driven?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

How do you open a cluster administrator?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

How to list all schemas in a database?

0 Answers  

---

How do I perform an unattended install of sql server 2000?

0 Answers  

---