SQL Server Performance Forum – Threads Archive
Create DWHi everyone, I just begin studying about Analysis Services. It seems SQL Server 2000 doesn’t support creating a DW, is that right? Does SQL Server 2000 only help analyze data? Thanks
I think you haven’t completed the study on AS, SQL server 2000 is only product which has enhanced data warehousing process. Referhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2805 for more information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
"It seems SQL Server 2000 doesn’t support creating a DW, is that right?" No that is not right, as a matter of fact SQL Server 2000/2005 comes with an arsenal of tools for creating and populating datawarehouses/datamarts. Analysis Services is only a component for Analyzing data from a warehouse/mart through Cubes or Mining Models. It is the layer that sits on top of your datawarehouse. Here are some other helpful links on Datawarehousing in SQL Server. http://www.microsoft.com/sql/evaluation/bi/default.mspx