As per most SQL performance questions, it depends? is generally the answer.

As a rule of thumb in my current environment we put indexes on all foriegn keys.

This is because we...

Hi Jay,

After Running a similar sized Datawarehouse (without Cubes) the following is the main advice I can give you.

1) Business rules for validating and cleaning the Data take the...

Hi

For your setup I would be inclined to have a 50GB o/s Partition and leave the rest as one large partition for SQL Server.

The partitions will not improve performance...

I have a wee 60GB Disk, the big problem is backing up all of my Wifes Photos.

Takes 20 CD's just for that, will have to splash out on a DVD-R...