Yet Another Database Thread. I have been doing some research for a final data warehousing project. I am looking for comments on using the new features of sql server 2008, star pattern for dimensional analysis. http://technet.microsoft.com/en-us/library/cc278097.aspx This seems the right way to store time series data in a RDBMS for fast/complex queries on time series.