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

750 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

Do you spend so long manipulating your data into something vaguely useful that you...

It was neat to stumble on this in the book, a piece by me,...

Forgive me for the title. Mentally I’m 12. When I started my current day...

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Comments posted to this topic are about the item Expanding into Print

Comments posted to this topic are about the item Downtime Caused by the Postgres...

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('Steve', 'Stan')

Assume preview features are enabled.