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

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

115

---

What are the properties of the transaction?

968

---

Why can there be only one clustered index and not more than one?

930

---

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

921

---

Which tcp/ip port does sql server run on? How can it be changed?

976

---

What is meant by dirty read?

950

---

What does ss stand for sexually?

1009

---

What do you do in data exploration

927

---

Explain different types of Normalization.

1733

---

Explain the phases a transaction has to undergo?

985

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

960

---

What are the difference between primary key and unique key? : sql server database administration

892

---

Tell me the phases a transaction has to undergo?

917

---

What are pages and extents? : SQL Server Architecture

956

---

How to install sql server 2005 express edition?

1055

---