SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • 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
  • CREATE or REPLACE feature request

    I remember back when I moved from Oracle to 6.5 I found the lack of a create or replace really annoying. Whenever I create new sps I always curse at not being able to do "create or replace myproc..." having to do "if exists (select 1 information_schema...)" or "if object_id(...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 19 2006
  • TSQL turning into C#

    Following my previous post about the requirement of semi-colons when using service broker statements, I have raised a suggestion to improve the "Incorrect syntax near ..." error message. If you find the above message less than helpful, then vote for the suggestion.
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Oct 6 2006
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems