Denormalization is a technique to move from higher to lower normal forms

What is de-normalization and when do you do it?

Question Posted / praveen

Answer Posted / praveen

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are information schema views?

992

What is updatable resultset?

1013

You want to use a perspective in an mdx query. How do you select the perspective?

239

Explain the steps to create and execute a user-defined function in the sql server?

977

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

974

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1020

can an order by clause be used in a creation of a view?

1185

how to define testing of network layers? : Sql server database administration

976

What is normalization and denormalization in sql server?

1020

What is the difference between varchar and nvarchar datatypes?

1093

Write a SQL command to insert and update only a particular field?

1118

Do you know what are the steps to process a single select statement?

978

can an automatic recovery be initiated by a user? : Sql server administration

958

What is lock escalation? : sql server database administration

1164

What is the command used to check locks in microsoft sql server?

1046