asked on
ASKER
ASKER
ASKER
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
TRUSTED BY
YES
... and the primary key on all dimension tables ?
YES
I'm really rather surprised you have "dims & facts" without indexing.
In SQL Server the most important indexing decision is what will be the used for the clustered index as this shapes the physical means of storage on disk.
Are you absolutely certain there are no indexes on any of these tables?