Cumulative update package 3 for SQL Server 2005 Service Pack 2
In August Microsoft released cumulative update package 3 for SQL Server 2005 Service Pack 2.
List of fixes related to SQL Server Analysis Services 2005 SP2:
SQL bug number | KB article number | Description |
| 50001585 | 938712 | FIX: Some records in the fact table may not be processed when you process a dimension that contains many attributes or many members in SQL Server 2005 |
| 50001586 | 940129 | FIX: An MDX query does not return results when you execute the query against a cube that contains an unnatural hierarchy in a dimension in SQL Server 2005 Analysis Services |
| 50001517 | 940160 | FIX: Error message when you deploy a SQL Server 2005 Analysis Service project that contains many cubes, and the cubes contain linked measure groups: "Unexpected internal error" |
| 50001382 | 940373 | FIX: The performance of a Multidimensional Expressions query in SQL Server 2005 Analysis Services Service Pack 2 is much slower than the performance in earlier builds of SQL Server 2005 Analysis Services |
| 50001609 | 940939 | FIX: Data is not rolled back after you roll back a transaction that contains a writeback operation in SQL Server 2005 Analysis Services |
| 50001573 | 940949 | FIX: You receive an error message when you run an UPDATE CUBE statement to update a cube in SQL Server 2005 Analysis Services |
| 50001576 | 940962 | FIX: When processing a dimension on SQL Server 2005 Analysis Services an error is raised with the following format: "The following file is corrupted: Physical file: \\?\<datafilepath>\MSMDBuildLevelStores_avl_672_29775_njzs2.tmp. Logical file ." |
| 50001415 | 940377 | FIX: Error message when you process cubes for one of the named instances of SQL Server 2005 Analysis Services: "Error opening file" |
| 50000872 | The MDX query performance is slow in SQL Server 2005 Analysis Services because SQL Server 2005 Analysis Services does not reuse the data cache | |
| 50001368 | 940372 | After you install SQL Server 2005 Service Pack 2, the performance of a MDX query is 10 times slower than the performance on SQL Server 2005 Analysis Services build 1555 |
| 50001461 | When some MDX queries are executed at the same for the same role or for the same user in SQL Server 2005 Analysis Services, the CPU usage is very high | |
| 50001164 | FIX: Error message when you connect to an instance of SQL Server 2008 Analysis Services by using the AMO library that is included with SQL Server 2005 Service Pack 2 Analysis Services: "Cannot connect to Analysis Services version '10.0.1019.17'" |
Found via Chris Webb blog.
Tags: news, cumulative update