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 is it’s similarity with sql server?

160

---

What is table valued function and scalar valued functions?

986

---

What is key set driven?

893

---

What is a performance monitor?

921

---

What is the difference between indexing and hashing?

1078

---

Do you know sql server 2008 introduces automatic auditing?

907

---

What is ssrs?

117

---

What is the web service used for reporting services?

114

---

What are null values in ms sql server?

1022

---

What are filegroups in sql server?

1012

---

What is the difference between clustered and non-clustered indexes in ms sql server?

937

---

What are the advantages of stored procedure in sql server?

833

---

Why we use the openxml clause?

955

---

What do you understand by recursive stored procedure?

873

---

What is logshipping and its purpose?

944

---