Data Warehousing - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Data Warehousing (RSS)
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 this, especially...
Posted by simonsabin | with no comments
Filed under: ,