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.

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

Explain system views?

0 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

what is hash table

3 Answers   ILFS, Teledata,

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

Explain filestream storage of sql server 2008?

0 Answers  

---