We build data warehouses using SQLServer 2000 Standard on WIN2K Advanced
Server (I know this is an Oracle list but these are design questions)

We are lucky enough to be building a new backend with an EMC Clarion at
the backend. This is my opportunity to redesign a lot of things. These
are the ideas I have and I would appreciate feed back

* Logical groupings of data files, file groups and drive
partitions
* read from the RAW file group and write to the DDM file group
* Should the development environment be striped and production
RAID5
* Can we set it up so all processes write to different partitions
(if we are logging everything those should be written to a different
drive letter)
* Would we see a gain from partitioning tables. Should I cluster
servers and build my cubes that way for performance reasons?

-Kevin

Oracle LazyDBA home page