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

At Redgate, we’re experimenting with how AI can help developers and DBAs become better...

I was messing around performing investigative work on a pod running SQL Server 2025...

Redgate recently released SQL Compare v16, which included a new feature to work with...

Comments posted to this topic are about the item What is Page Density

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Looking to confirm my understanding of these three products and how they can be...

In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?