Hi I need some advice on designing a DataWarehouse... We are currently using 2000 (upgrading to 2005 soon) for out OLTP database which is currently about 90GB. Currently we run stats, etc. over a read only copy of our live database which is kept upto date by log shipping. Unfortunately, the queries being run over the read only are taking longer and longer, so was decided we need a Data Warehouse so that we can run these stats queries quicker, and have more historical data to play with (because we delete quote a lot of data from the OLTP at the moment), and also to allow some data mining type queries. As I don't have any experience in this area, we have a Consultant in to help guide us on this. After reading up on data warehouses, I was convinced that we would be designing the data warehouse database with a star or snowflake schema. However, the consultant who has been involved in designing data warehouses for years, for some big companies, and for different databases, says that we shouldn't be using star schema. We are basically going down the route of the data warehouse database being a normalised database very similar to the OLTP database. I am quietly concerned about this, and don't really have the experience to challenge this decision. Does anyone else have experience of this?... is there valid reasons to use a normalised database for data warehouse as opposed to star schema?... would anyone else have concerns about doing this? I thought that we would probably be using Analysis Services over the data warehouse database... would Analysis Services be okay creating cubes over a normailised DB or does it need to be star/snowflake schema? Thanks in advance for any help or advice.