Category: Data Warehousing – DW

Data Warehousing - DW August 29, 2014 6 min read

Creating a Simple Date Dimension Using Recursive Common Table Expressions (CTE)

In this post I’ll explain how to create a simple date dimension to use it in your data warehouses and…

Business Intelligence - BI August 4, 2013 10 min read

The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new…