Browse by Tags

All Tags » Data Warehousing (RSS)
05 May 2011 00:27

Next generation Data Warehouse : Free London Event

Are you working in Data Warehousing then this event might be for you. Together, Microsoft and HP are engineering an innovative product range that combines our leading edge software and hardware assets into optimized data-warehouse appliances. In addition...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
31 July 2007 23:10

How to speed up partition merging

The key to performance with partition management is to deal with empty partitions. That way all you have is meta data changes and no data has to be copied. We recently encountered a situation where we had two partitions and wanted to merge them. In a...
Posted by simonsabin | with no comments
Filed under: , , ,
26 June 2007 09:04

Time dimension - What should the key be?

We are currently implementing a data warehouse and the design of the time dimension was recently being done. Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , ,
18 May 2007 17:54

Too Dim or not Too Dim

No i'm not talking about a new Harry Enfield sketch about a posh bloke that's a bit thick, I 'm talking about tables in a warehouse. Many people insist on naming tables DimCustomer, Dim Product etc and FactOrderLine. What is the purpose of...
Posted by simonsabin | with no comments
Filed under: ,