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

746 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

689 reads

If you're an attendee at the PASS Data Community Summit this year, there are...

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...

Comments posted to this topic are about the item Personal Contact Is Vital

Comments posted to this topic are about the item Getting the Schema for Tables

Comments posted to this topic are about the item An Unexciting Exciting Release

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO