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

How to delete duplicate records based on single column from a table?

1031

---

Write a sql query to sort on different column name according to the parameters passed in the function?

883

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

991

---

What is a deadlock and what is a live lock?

982

---

What are the dis_advantages of stored procedures, triggers, indexes?

2205

---

What are the steps to follow to configure SQL*Net?

1019

---

What is the purpose of optimization?

982

---

What is the distinction amongst delete and truncate?

1048

---

What is the difference between migration and upgradation in sql server?

1083

---

What is the cartesian product of table?

995

---

What is the partitioning method?

1006

---

What is the difference between varchar and varchar types?

1060

---

How many replicas are maintained for each SQL Azure database?

142

---

Explain contrast amongst grouped and non-bunched records?

1007

---

What is a schema in ms sql server 2005?

952

---