Answer / Sharad Singh

Normalization is used to eliminate data redundancy, improve data integrity, and simplify database management in SQL Server. By dividing a large table into smaller tables and defining relationships between them, it minimizes the chance of data inconsistencies or anomalies, making the database more efficient and easier to maintain.

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers   BirlaSoft,

---

What is relationship? What number of sorts of relationship are there?

1 Answers  

---

How to create nested stored procedure?

1 Answers  

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---

What are the advantages of stored procedure in sql server?

1 Answers  

---

Tell me in brief how sql server enhances scalability of the database system?

1 Answers  

---

What are the advantages of log shipping?

1 Answers  

---

What is the difference between local and global temporary tables?

1 Answers  

---

What is collation?

1 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1 Answers  

---