Answer Posted / hari

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

how you can deploy an ssrs report?

172

---

What is the difference between locking and multi-versioning?

941

---

Does partitioning improve performance sql server?

900

---

What do you mean by sql server 2005 express management tools?

1254

---

Why would you call update statistics?

961

---

Explain iaas, paas and saas?

90

---

What is the difference between for trigger and after trigger?

1028

---

What is a view and what are its advantages?

1055

---

Explain the difference between cross join and full outer join?

925

---

Differentiate sql server reporting services vs. Crystal reports?

188

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

935

---

Which tools are available to manage SQL Azure databases and servers?

113

---

How do you rename a table in sql server?

940

---

Do you know what is a with(nolock)?

1001

---

What is data source in connection string?

852

---