Monthly Archives: December 2007

Moving SSAS databases

Posted on December 10, 2007 by Clay Lenhart

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. http://www.ssas-info.com/ssas_faq/ssas_management_faq/q_how_do_i_move_analysis_services_database_to_a_different_folder.html

Posted in SSAS | 6 Comments

Natural Keys vs Surrogate Keys

Posted on December 10, 2007 by Clay Lenhart

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

Posted in SQL Server Development | 9 Comments

SSRS filter values missing from a SSAS datasource

Posted on December 10, 2007 by Clay Lenhart

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 … Continue reading →

Posted in SSAS, SSRS | 5 Comments

SAN RAID Performance

Posted on December 9, 2007 by Clay Lenhart

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): More disks == faster … Continue reading →

Posted in Hardware | 22 Comments