Answer / saji joseph

Active/Active

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.

Answer / ali

Saji, you answer is ok, but there are some things that need
to be cleared here. Node = Windows Server, Instance = SQL
Server Installation

1.I find that more people use the terms Active/Active and
Active/Passive to detail what the cluster is actually doing
(rather than single instance or multi-instance).
2.An active/passive cluster can have two instances of sql
server running on the active node and the passive node being
idle waiting for a failover to happen.
3.Also, it is not required that in an active/active cluster
one node has default instance and the other node has named
instance, where infact both nodes can have named instances
as part of the virtual server.

ACTIVE/ACTIVE Cluster:
Active/Active clusters is really a mutli-instance (in terms
of SQL Server) cluster with each node owning a running
instance with resources leading to both nodes Actively
running business logic. Both nodes can be possible owners of
each others resources should a failover occur

ACTIVE/PASSIVE Cluster:
Active/Passive clusters is normally single instance of SQL
Server (although I have come across a few cases of
multi-instance) that runs on one node Actively and the other
node does nothing but sit and wait for a failover to occur
(passive node).

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

What are views in ms sql server?

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

0 Answers  

---

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

Why should we go for stored procedures? Why not direct queries?

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

What is ms sql server triggers?

0 Answers  

---

Which are ddl commands?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---