Posted by Tony Rogerson on 11/03/05 09:24

Thats just not true.

SQL Server 2005 introduces the Unified Dimensional Model (UDM) that helps
you build a dimensional model over your relational structure using Data
Source Views; depending on your schema there is often a case when you don't
need to build a specific seperate physical star schema.

Check out http://www.microsoft.com/sql/analysis/overview.mspx as your
starting point.

As well as a very powerful and reliable RDBMS engine, the SQL Server product
set comes with Analysis Services (you should know that if you post in the
Microsoft SQL Server forums), that is a highlighy scalable, in 2005 anyway,
dimensional query engine using MDX.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1130937250.736180.274310@g49g2000cwa.googlegroups.com...
> Without any other information I would go with the Star schema. But I
> would not use SQL Server since it does not have an optimizer that is
> meant for this kind of work. DB2, Teradata, etc. can handle this much
> better.
>

[Back to original message]