Cumulative update package 4 for SQL Server 2005 Service Pack 2
In October Microsoft released cumulative update package 4 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 |
| 50001663 | 929375 | FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application |
| 50001741 | 940870 | FIX: Error message when you process the index for a partition in a cube in SQL Server 2005 Analysis Services: “Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3311, function 'PFFileStore::HandleDataPageFault')” |
| 50001670 | 942654 | FIX: A Multidimensional Expressions query that contains a FILTER function returns an incorrect result in SQL Server 2005 Analysis Services |
| 50001784 | 942667 | FIX: The Analysis Services service stops unexpectedly when you run a Multidimensional Expressions query that uses unary operators on a dimension in SQL Server 2005 Analysis Services |
| 50001605 | Error message when you run a MDX query: "Internal Exception." | |
| 50001702 | After you upgrade SQL Server 2005 Analysis Services from Service Pack 1 to Service Pack 2, the query performance is slow because the number of the Calculate Non Empty Current event class greatly increases. | |
| 50001710 | After you upgrade SQL Server 2005 Analysis Services Service Pack 1 to Service Pack 2, the performance of a Serialize Result Current event class is 20 times slower than in Service Pack 1. | |
| 50001742 | In SQL Server 2005 Analysis Services Service Pack 2, frequent access violations occur in the "PFCompressIterator::DecompressArray" function under stress conditions. | |
| 50001782 | You cannot configure the security settings for database dimensions when the database name is the same as the cube name. |
Tags: news, cumulative update, non empty, partition