Answer Posted / anirudh

Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.

How the authentication mode can be changed?

1175

---

What is clustered vs nonclustered index?

998

---

Explain different forms of normalization?

1001

---

What is history table in sql server?

1028

---

what is the main function of a query parameter?

155

---

What are commonly used mssql functions in php?

1141

---

What is difference between sql and sql server?

1081

---

What does nvl stand for?

992

---

New concepts of sql server 2005 use in your project.

2399

---

When should you use an instead of trigger?

1018

---

What is it’s similarity with sql server?

160

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1090

---

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

1218

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1018

---

Can you tell me about the concept of ER diagrams?

1121

---