Answer Posted / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

875

---

Why use “in” clause in sql server?

995

---

How do I find the size of a sql server database?

877

---

How can we migrate from SQL server to SQL Azure?

113

---

How can you set the threshold at which sql server will generate keysets asynchronously?

939

---

What is the difference between local and global temporary tables?

1075

---

What is fill factor and pad index?

953

---

What is normalization process?

1107

---

How to use clusters?

882

---

What is the importance of three tier architecture?

1026

---

Can sql servers linked to other servers?

972

---

How do I perform an unattended install of sql server 2000?

1018

---

Tell me what is sql profiler?

979

---

can a table be moved to different filegroup? : Sql server administration

910

---

How to sort the query output with order by clauses in ms sql server?

983

---