A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. This is a great script
Tag: T-SQL
Date Dimension Using Computed Columns
Picked up this nice script from a client last week. Use this script below to create a Date Dimension for a data warehouse that is
Issues With Calculating Current Age Using DateDiff (Rounding?)
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age. It used the following expression, which could just as
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on a table. A lot of