T-SQL – Devin Knight

Modified Insert Unknown Row to Dimension Table

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

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

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

IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more problems than it does solve

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