I've to recommend a new server for a datawarehouse server which contain some
data warehouse databases (5 databases of 5Gb each)
I plan 6gb of memory and some SCSI drives (5 * 18 gb in raid 5 + 2 * 18 gb
in raid 0 for the tempdb)

I'm programming a report with reporting services accessin to a OLAP database. Analysis Services and Reporting Server are installed on a Windows 2003 Server
When I show the report with the preview option it works fine. The data is showed correctly. But when I try to execute the ...

Is it possible to transpose data from a table?
I have data in the format shown below
Date     Hour     Price
5/21/04  1        5

We currently have 6 fairly large fact tables (10 to 30 millions rows per
table). They become complex to manoeuver for OLTP and DB maintenance
tasks (too execution time).
We are considering splitting these fact tables by smaller ones, based on

I'm involved in building a medium sized ware house with MS SQLServer 2000
as the backend. I've been searching for some good tools for SQLServer to
help me with the demanding tasks of planning and building the database and
(preferrably the same tool) making the mappings and data ...

I cant wait for Microsoft to put these idiots out of business
so i can stop working on the crap

We are using MS SQL Server 2000 with its Analysis Services and Excel 2002
We have 3 facts tables (less than 100 rows each)
8 dimensions (from 10 to 1000 members)
3 regular cubes and 1 virtual cube (with 20 calculated members)