February 2009 - Posts

0
Comments

INSERT values into IDENTITY columns by MartinIsti

Yesterday I had to recreate a table because it has different a column order in the DEV and in the TEST environment. Since it was too large to drag-and-drop column on the SSMS table design screen I had to use a very simple trick: script the table in SSMS...
0
Comments

Time hierarchy - desc order by MartinIsti

Yesterday I received the task to change the order of our time dimension from ASC to DESC. As easy it is in SQL that difficult it is in AS. Or so it seemed. First I tried looking for a solution among the properties. After finding nothing I began thinking...
Filed under: , ,
0
Comments

Little deployment utility (for DTUTIL) by MartinIsti

Today I did not want to use the package deployment wizard so I decided to automate a little our package deployment by using a batchfile with DTUTIL commands. I've created an Excel file with some expressions so the user just need to fill in some mandatory...
Filed under: , , ,
4
Comments

Star or Snowflake i.e., 1 or 2 Dim tables? by MartinIsti

Last week I had to design and sketch a more or less simple OLAP solution during which I had to face a certain dilemma. But before going into details I'd like to share some background. The OLTP source system is in Oracle: The first fact table row points...
Filed under: , , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems