In a former life on a SQL Server 2000 project with I had the immense joy of building a few cubes in Analysis Services that took advantage of many-to-many relationships. At the start I was thrilled to be trying something new and by the end I was cross-eyed trying to keep all of the calculations … Continue reading IIF(IsEasier(Many-to-Many Dimensional Modeling) = TRUE, JOYFUL, CRY)
Tag: Archive
The 2-for-1 Special in Excel
It inevitably happens when building SQL Server Reporting Services reports that someone will have desire to export the beautifully created report out of SSRS and into some other format. And sometimes that format just happens to be Excel. *Presto Change-O* And quite suddenly the beauty of the report is destroyed by the earth-shattering disease of … Continue reading The 2-for-1 Special in Excel
It’s All About The NULL
I read a couple of NULL articles back-to-back today from SQLServerCentral. The first had to do wit the Four Rules of NULL and the second was NULL Versus NULL. Both were pretty good and picked up on how SQL Server uses and characterizes NULLs. I can think of a handful or fifty times that the … Continue reading It’s All About The NULL
SQL 2005 White Paper: Online Index Operations
How quickly a week goes by... minute by minute... get a little busy and no blogs. Well, here's a quick link to a white paper on Online Index Operations in 2005. A very nice 2005 Enterprise feature that allows building and maintaining of indexes without sacrificing DML concurrency. Or in other words, how to keep … Continue reading SQL 2005 White Paper: Online Index Operations
Strate SQL 