Answer / swapna

As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.

Answer / praveen

Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.

Answer / praveen

If the database developer might want a reversal of
normalization to improve performance is called
denormalization.

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is the ‘fillfactor’?

0 Answers  

---

What is dml command?

0 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

What are the fixed server level roles? : sql server security

0 Answers  

---

---

What is the order in which the sql query is executed?

0 Answers  

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

What is the purpose of sql profiler in sql server?

0 Answers  

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---