We have a Server for DATAWAREHOUSE on SQLSERVER 2008. server specification : DB Size for DW = more than 800GB Processor = 4x six core xeon 2,6Ghz (total 24 core) RAM = 65 GB Hard drive = 2TB what do you think, is the RAM enough ?

to answer this question you should ask yourself what is size of the cube? a good practice can be that RAM be big enough to cover cube spacehttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com