Answer / Nitin Kumar Sharma

Normalization is a process to organize data in a database to reduce redundancy and improve efficiency. It involves several normal forms (1NF, 2NF, 3NF, etc.). De-normalization is the opposite process, where redundant data is intentionally introduced for performance or convenience reasons.

How to rebuild the master database?

0 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

What are the database objects? : SQL Server Architecture

1 Answers  

---

what is denormalization and when would you go for it? : Sql server database administration

1 Answers  

---

What is trigger explain with program?

1 Answers  

---

Tell me what are the advantages of using stored procedures?

1 Answers  

---

What is user-defined scalar function?

1 Answers  

---

How to create new databases with "create database" statements?

1 Answers  

---

How to create new table with "create table" statements?

1 Answers  

---

what is a check constraint?

1 Answers  

---

Explain multiserver query

1 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1 Answers   Global Logic,

---