Ziek's SQL Home

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...

2012-05-04

749 reads

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.

There are...

2012-05-03

692 reads

Superheroes and saints never make art. Only imperfect beings can make art because art...

One feature that I have been waiting for years! The new announcement around optimize...

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

Comments posted to this topic are about the item A Big PK

Comments posted to this topic are about the item The AI Bubble and the...

In SQL Server 2025, how many columns can be included in a Primary Key constraint?