Answer Posted / mamatha

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 is collation sensitivity? Explain different types.

1016

---

What is database mirroring?

1123

---

What is the use of set nocount on/off statement?

1101

---

What is buffer cash and log cache in sql server?

1131

---

Explain having clause?

972

---

Is the primary key column of a table an index in ms sql server?

965

---

What is a Join and explain its types?

1109

---

What is the usage of the sign function?

1123

---

Does partitioning ssd reduce performance?

898

---

What do you mean by the term 'normalization'?

1220

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

999

---

What do you understand by a view?

1007

---

What is the difference between web edition and business edition?

111

---

Explain what are the events recorded in a transaction log?

1008

---

How to search for a string in all stored procedure in sql server?

1008

---