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.

What are user-defined functions (udfs) in sql server?

988

---

Do you know what are pages and extents? : SQL Server Architecture

993

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1048

---

Define views.

1010

---

What is difference between count (*) and count 1?

923

---

What is the function of sql server agent windows service?

1093

---

What is the difference between dropping a database and taking a database offline?

1172

---

What do you understand by a view? What does the with check option clause for a view do?

996

---

Explain the different types of backups available in sql server? : sql server database administration

922

---

How can you hide the sql server instances?

1021

---

Why de-normalization required?

995

---

What is the new security features added in sql server 2014? : sql server security

996

---

Can a table be created inside a trigger?

967

---

What are constraints?

1006

---

What stored procedure would you use to view lock information?

975

---