Slowly Changing Facts
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,722 reads
Mark Murphy
Incremental Data Loading Using CDC
Describes a design pattern for using CDC to power fast and efficient incremental data loads.
2013-06-07 (first published: 2011-01-17)
28,969 reads
Using FULL JOINs to Compare Datasets
This article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance.
2013-04-23 (first published: 2010-09-27)
30,782 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Being Mindful of Design Time
Comments posted to this topic are about the item Being Mindful of Design Time
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers