Moving SSAS databases
Here is an article on moving SSAS databases. The only thing to add is to be sure to set the file permissions on the folder.
Here is an article on moving SSAS databases. The only thing to add is to be sure to set the file permissions on the folder.
This blog entry has a good description of the pros (and some cons) of surrogate keys:
http://rapidapplicationdevelopment.blogspot.com/2007/08/in-case-youre-new-to-series-ive.html
I recently ran into a problem where the list of values in a filter were missing for a dimension. It was due to having a fact relationship from the dimension to a very small fact table. In fact, the table was empty. I resolved it by changing the relationship to a regular relationship. Sure it will be less efficient, however the fact table is expected to be very small.
It is difficult to find information on how different RAID levels perform. I did some performance testing with 14 SCSI disks in a SAN, and came up with the following conclusions (heavy dose of salt needed):
SQL Server notes:
More Information:
Graphs:
(I don't show MB/s above 150 MB/s because the 2Gb/s cable was saturated at 160 MB/s).

The RAID level matters when writing:

The RAID level doesn't matter when reading:

The RAID level matters when writing:
