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
Category: 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
IntelliSense Slow to Refresh
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 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