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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

730


how many no of arguments can be passed in procedures and functions

5059


Does partitioning improve performance?

718


Can you type more than one query in the query editor screen at the same time?

772


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

748






What is faster join or union?

797


What is format parameter in ssrs?

128


What is a unique index?

674


How to find index size for each index on table?

770


Explain the concept of view and Types of views in SQL server?

774


How to create a view using data from another view?

729


Is resultset an interface?

718


What is identity?

761


What is database black box testing?

773


Distinguish between nested subquery and correlated subquery?

751