Fill Missing Dates without Loops

A common task Database Developers must perform is to create a query that returns data for a date range. All dates must be returned regardless of if there is data for a given date. This is a solution that is fast. Continue reading

SSAS – Duplicate Attribute Key Error

Today I was working with SQL Server Analysis Services 2008 and it connects to a SQL Server 2008 database engine to pull data for a dimension.  In my dimension I have a bunch of columns that are bits describing whether … Continue reading