A lot of people in the organisation think that its not especially when it
comes to large datawarehouse systems. What does one do to argue the same ?
They claim Oracle or DB2 are much better.

I am in the first step of creating a data warehouse and am in an argument
with my co-worker on structure.
I have two locations both using sqlserver 2000.  Each location has a
location id.  (1 and 2).

When installing Reporting Services, I get an error "The
installer has encountered and unexpected error installing
this package. This may indicate a problem with this
package. The error code is 25619. This happens at the very

Is it just me or is it that you give it a workload and it recommends the
indexes you already have on your table.
Anybody any experience with this 'tool'?

I am new to this OLAP stuff.
I am trying to create a cube which has a count of sales per month per year.
How do you make a datetime field a dimension of a cube?
I seem  to specify the dimension OK and get the Year Month heirarchy I want

during the cube generation, I saw the disk utilization in C drive is 100%.
How can I change the temporary drive for the cubes generation?
or
can I share the work load on others drives? nHow?

A couple months ago we started a report server MS SQL Reporting Services.
The MS SQL is of course licenced but the Microsoft dealer by mistake sent us
an evaluation version of RS. We've used it for a couple of months and
yestarday it stopped working - its evaluation period passed. ...

What's the best Microsoft tool for data modeling of a data warehouse on SQL
Server 2000?