We build data warehouses using SQLServer 2000 Standard on WIN2K Advanced
Server
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. I know in Oracle
they cluster servers and run their apps. that way for performance gains

-Kevin

MS Sql Server LazyDBA home page