Tag: Data Modelling

Part 3 : Does data archival strategy matters ?

This article is the part of Does it matter ? series. We'll discuss various aspects to save cost and optimize the database performance by archiving the data.

Normalization vs Performance – SQL Server

Are you dealing with high volume online data and having trouble in performing online analytics over it? Normalization could be one possible reason behind poor performance of your queries. Every solution has some trade-off so normalization also has. If your data is extensively normalized then you may be performing a lot of joins in order to … Continue reading Normalization vs Performance – SQL Server