SQL Server Performance

Create DW

Discussion in 'Analysis Services/Data Warehousing' started by vietcave, Aug 19, 2005.

  1. vietcave New Member

    Hi 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

  2. satya Moderator

  3. Raulie New Member

    "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
    http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx

    Raulie
    hp

Share This Page