Normalization & Indexes Data redundancy negatively affects storage scalability and responsiveness. Learn how to use database normalization and indexes in SQL Server to counter these negative effects.