In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made me study and compare the Table Compression feature of SQL Server. This article will not explain Compression but will compare the storage and performance aspects of … Continue reading Storage savings with Table Compression
Category: Database Design & Architecture
Clustered Index Key – Natural or Surrogate?
This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of an experiment.
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.
Part 2 : Does storage architecture matters ?
This article is the part of Does it matter ? series.
Part 1 : Does database modelling matters ?
This article is the part of Does it matter ? series.
SQL Server Carpenter 