Normalization

Consistent Data Presentation

Design

Checksums

EAV Model

Changing Table Schema – what goes behind the scenes – Part II

Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.

Changing Table Schema – what goes behind the scenes – Part I

What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.

SSAS Cubes

Physical join

What is affected by IGNORE_DUP_KEY?