February 2006 - Posts

• Memory configuration (no pitfalls!) in SSAS

  I recently had some problem with memory configuration of SQL Server Analysis Services 2005 and I'd like to share lessons I got. This post is a replacement for my previous post , that I striked to keep history of some bad assumptions I initially made. Read More... Posted Friday, February 17, 2006 7:58 PM by Marco Russo (SQLBI) | 3 Comments

• Memory configuration pitfalls in SSAS

  I recently discovered a few pitfalls on memory configuration of SQL Server Analysis Services 2005: the main problem is that the default configuration (written by setup) doesn't consider the actual physical resources (mainly RAM) of your server and this Read More... Posted Thursday, February 16, 2006 9:15 AM by Marco Russo (SQLBI) | 2 Comments

• Excel 2003 OLAP customization with VSTO

  Thanks to Romeo Pruno , I just discovered a sample of Excel 2003 customization to access OLAP data through task panes. While this article deserves to be read, I think that client customization is a sort of "last resort", to be applied only for particular Read More... Posted Wednesday, February 15, 2006 4:34 AM by Marco Russo (SQLBI) | 0 Comments

• Report Builder trouble filtering date with UDM

  Thanks to a blog reader, I just discovered that if you create a Report Builder Model from a UDM and try to create a report filtering a date field, the date you specify in the filter dialog box is inverted (months with days) when the MDX query is generated. Read More... Posted Tuesday, February 14, 2006 7:17 AM by Marco Russo (SQLBI) | 0 Comments

• Post SP4 hotfixes for Analysis Services 2000

  I just discovered that some weeks ago Microsoft released a cumulative upgrades of hotfixes for Analysis Services 2000 released after SP4. I have to say that I noted AS 2000 is less stable after SP4 intallation (I can say that after months of use) and Read More... Posted Tuesday, February 14, 2006 3:43 AM by Marco Russo (SQLBI) | 0 Comments

• Alternative approach for SCD dimensions in SSIS?

  Tonight I've studied how to improve performance of SCD transformation task of SSIS. I started from the consideration that in an actual SSIS package, the dimension processing is at least one magnitude slower than fact table processing; most of the time Read More... Posted Wednesday, February 08, 2006 6:33 PM by Marco Russo (SQLBI) | 0 Comments

• CalendarTransform component for SSIS

  I just downloaded and tried the CalendarTransform component for SSIS that Microsoft realesed with a shared source permissive license . It's a useful data flow transformation component that is able to generate apparently all of the attributes you can desire Read More... Posted Sunday, February 05, 2006 5:05 PM by Marco Russo (SQLBI) | 0 Comments