MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

1. 

Why is the width of rows important?

2. 

What does de-normalization imply?

3. 

Why should you avoid de-normalizing data that is frequently updated?

1. 

The width of rows is important because wide rows take up more space and can cause a waste of both memory and disk space.

2. 

De-normalization implies the storage of specific data redundantly.

3. 

You should avoid de-normalizing data that is frequently updated because of the cost of maintaining the redundant data.