(Baya Pavliashvili) Microsoft Analysis Services (MSAS) looks simple to use on the surface, but you’ll quickly discover otherwise when you start working with it daily. Backups are the topmost priority for any database administrator, so you’d think that backing up MSAS cubes would be straightforward,

The Spanish versions of some Microsoft SQL Server 2000 Analysis Services hotfix packages do not install correctly. Therefore, you cannot use Add or Remove Programs to remove the hotfixes as expected. You may receive an error that is similar to the following in the uninstall log for the hotfix: 0.0

(Serdar Yegulalp) Experts typically use Query Analyzer or a dedicated development product to do work in SQL Server, but they must contend with Query Analyzer’s many little limitations as a result. (R)

(Douglas Reilly) I have never met Adam Machanic, but I regularly read his blog as part of the SQL Junkies RSS feed. He is one of the authors of the recently released book Pro SQL Server 2005, in which he contributed chapters covering T-SQL for DBAs, .NET integration, and programming assemblies. He a

When you run a query against a cube that contains calculated cells in Microsoft SQL Server 2000 Analysis Services, memory usage increases for the Msmdsrv.exe server process. The memory usage increase will vary depending on the number of calculated cells that are defined in the cube and the number of

(Arthur Fuller) When a table grows to millions or even billions of rows, performance can be a serious problem. The last thing you want to do is a table scan. Unfortunately, you can’t do some queries any other way.

(Bayer White) Usually developers like having full control over their reports but what happens if you have someone designated to build reports who does not quite know the backend schema. A good way to separate the building of the data for the report and the report design could be stored procedures. N

On a server that is running Microsoft SQL Server 2000, the Analysis Services service may unexpectedly stop and then restart when the lazy aggregation thread rebuilds the flexible aggregations. This problem occurs on a server that is hosting a remote partition of a cube.

When you run the 64-bit version of SQL Server 2000 Analysis Services, system performance is decreased for user-mode applications on the server.

(William Pearson) One of the first tasks that awaits many of us, as Analysis Services administrators, architects, and / or consultants that work with client and employer data in Analysis Services 2000 cubes, is to provide guidance and support in the migration of the databases that house them to MSSQ