Answer Posted / sumit

A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime

What command would you use to add a column to a table in sql server?

1302

---

What are the different types of data sources in ssrs?

196

---

Can you please differentiate between a primary key and a unique key?

1001

---

How many levels of sp nesting is possible?

1045

---

What is proper subset of candidate key?

990

---

What is spid in sql server profiler?

1092

---

What type of Index will get created after executing the above statement?

1090

---

What is the difference between mysql and mysqli?

1184

---

What is the use of group by clause?

936

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

910

---

What is the difference between stored procedure and functions?

1120

---

What command is used to create a database in the sql server and how?

1169

---

Explain the first normal form(1nf)?

1019

---

What xml support does the sql server extend?

1001

---

Do you know what is user defined datatypes and when you should go for them?

960

---