SSAS Articles 
MDX IIF Function Query Hints in SQL Server Analysis Services 2008
MDX IIF Function Query Hints in SQL Server Analysis Services 2008
| IIF Function Query Hints in SQL Server Analysis Services 2008 |
| Written by Richard Tkachuk |
| Thursday, 04 September 2008 00:54 |
|
Thomas Kejser and I are doing some work to produce the SQL Server 2008 Analysis Services Performance Guide. Among a bunch of other things, it discusses the IIF function. But because I recently mentioned MDX query hints in a recent podcast, I wanted to get this out quickly. Some references are a bit hazy (expensive vs inexpensive query plans, default values and the like) and I’ll elaborate either in future blogs or in the white paper itself. Anyway, the IIF mdx function is a commonly used expression that can be very costly to evaluate. It takes 3 arguments: Read more...
|
Latest Author Articles
- Handling Begin and End Times in SQL Server Analysis Services 2008
- IIF Function Query Hints in SQL Server Analysis Services 2008
- Richard Tkachuk discusses the SQL CAT team, working with Analysis Services
- Querying Dimension Members In Analysis Services
- Reverse Running Sums and Set Aliases (by Richard Tkachuk)
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
