Author: admin

Analysis Services: Solving Hierarchy Errors of Uniqueness

No Picture

Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes…

Read More »

Cost Threshold and Max Degree of Parallelism

No Picture

SQL Server has many options for configuring a database system. Most do not become apparent until some part of the system does not function “properly”. Parallelism is one of these settings. You will see Waits for Parallelism and…

Read More »