I suggest you read this article:

http://www.sqlservercentral.com/articles/T-SQL/70167/

and even more importantly read the discussion of the article. Personally I lean toward the general opinion of the discussion rather than the article, but together I think they give pretty full treatment to the Time Dimension.