MS released Cumulative update package 5 for SQL Server 2005 Service Pack 2
On December 19th Microsoft released cumulative update package 5 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 |
| 50002065 | 943526 | FIX: SQL Server 2005 Analysis Services stops responding when you run an MDX query that references a measure of the double data type or a calculated member of the double data type |
| 50001842 | Query performance regression occurs in SQL Server 2005 Service Pack 2 for some queries that involve large named sets and mixed-grain cell coordinates. | |
| 50001890 | When you create a local cube in Microsoft SQL Server 2005 Analysis Services, some user-defined hierarchies are missing from the local cube. This problem occurs if you filter some dimensions of the source cube. | |
| 50001912 | When you make predictions by using a mining model in Microsoft SQL Server 2005 Analysis Services, the operation takes a long time to execute. This problem occurs if the mining model uses the Microsoft Neural Network algorithm. | |
| 50001935 | You cannot run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services because a calculation failure occurs in the "msmdsrv!MDDisjointUnionEvaluator::Evaluate" method. | |
| 50001952 | A Multidimensional Expressions (MDX) query takes a long time to finish in Microsoft SQL Server 2005 Analysis Services. | |
| 50001967 | When you use a mining model to generate predictions, the prediction process may take a long time in Microsoft SQL Server 2005 Analysis Services. | |
| 50002006 | A Multidimensional Expressions (MDX) query returns an unexpected result based on the cache status in SQL Server 2005 Analysis Services. | |
| 50002012 | When you use a Multidimensional Expressions query to query a named set, the query returns a different result in SQL Server 2005 Analysis Services after you install SQL Server 2005 Service Pack 2. | |
| 50002016 | Cumulative Update Package 3 for SQL Server 2005 Service Pack 2 may not resolve the performance issue that is described in Microsoft Knowledge Base article 940945. | |
| 50002031 | HTTP access to an instance of SQL Server 2005 Analysis Services fails if you use a proxy server that requires authentication. | |
| 50002035 | A Multidimensional Expressions (MDX) query returns different results in SQL Server 2005 Analysis Services after you install SQL Server 2005 Service Pack 2. This problem occurs because an incorrect value exists for the CalculatedVisualTotalStyleForSubselects option. | |
| 50002036 | An MDX query returns different results in SQL Server 2005 Analysis Services. This problem occurs because the non-empty operation loses members after you install SQL Server 2005 Service Pack 2. | |
| 50002061 | When you use the SUM function in a SCOPE statement, you may obtain an incorrect result in SQL Server 2005 Analysis Services. | |
| 50002062 | After you install SQL Server 2005 Service Pack 2, MDX scripts may return incorrect results in SQL Server 2005 Analysis Services. |
Tags: news, cumulative update, non empty, subselect