in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • updating column with a random value

    I have been working recently on load testing of our ETL. One of the factors that determines amount of transfered data is a lookup table that is joined to the source. I populated this table with aproppriate values, and then realized that I also need some values in second column, and they were null. Let's...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Jan 13 2010
  • 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