in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • 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 merge you have 3 boundaries the left one, the middle...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 31 2007
  • 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. So considering the day dimension what should...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems