Answer Posted / ranjeet

normalization is used to remove data redundancy and
inconsitancy and we can perform the indexing,serching and
shorting the data in very easy manner

What are the different types of lock modes in sql server 2000?

949

---

Why normalization is used?

1012

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

977

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

992

---

What Are the Main Features of SQL Azure?

117

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

928

---

What is auditing in sql server?

927

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

150

---

How to select some specific columns from a table in a query in ms sql server?

1005

---

What is BLOCK statements in SQL?

1263

---

When cursors are useful?

1104

---

How to count duplicated values in a column in ms sql server?

1095

---

What is Federation Root Database?

104

---

What happens if ntwdblib.dll is missing on your machine?

1144

---

What are the different types of backups that exist?

1167

---