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?

IGNORE_DUP_KEY

Log File Page Size

Single Page Restore

Introduction to the Transaction Log

The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.