Question : After our DBA got sacked for poor performance, I am now our accidental DBA. I have been pushing […]
Tag: ssas
How to balance SQL Server memory with SQL Server Analysis Services memory
Question : We have many systems that have the same configuration One Server (virtual or physical) Running SQL Server (SQL) […]
remove Analysis service from a SQL 2014 cluster
Question : Is it possible to uninstall Analysis service from a SQL 2014 cluster. I’ve seen that it cannot be […]
SSAS Tabular QueryMode Confusion. Why Hybrid mode is useful?
Question : I read couple of articles about QueryMode in Tabular. I finally noticed that hybrid modes (DirectQuery with In-Memory […]
The ‘Database’ with ‘ID’ = ‘xxxxxxx’ doesn’t exist in the collection
Question : I have a SSAS Tabular server with 30 database. I also have a scheduled process to backup all […]
How to have MS Analysis server setup of both modes: multi dimension and tabular
Question : Ref: Is there a way to install both tabular and multidimensional modes? The answer was ..”You answered your […]
Problems attaching a SSAS database
Question : I am attaching a SSAS database that I have just moved to a different drive following the below […]
Can’t connect to Analysis Services or Reporting Services on localhost
Question : I’m able to connect to my SQL Server 2008R2 localhost Database Engine and Integration Services. However, when I […]
MDX query is SLOWER with warm cache
Question : I have a MDX query that executes faster on cold cache than warm cache. If I ran the […]
SSAS Tabular: ImpersonationMode that is not supported for processing operations
Question : I have a SQL 2016 SP1 SSAS Tabular Instance. I’ve deployed a model with the following properties When […]