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 PROJECTION Operation?

0 Answers   Infosys,

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

What is the architecture of ms sql reporting service?

0 Answers  

---

What are extended events in sql server?

0 Answers  

---

When would you use sql joins?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

How to check if a table is being used in sql server?

0 Answers  

---