# The Unpopular SELECT Statement

• Article

SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.

4.33 (52)

2009-01-30 (first published: )

# MDX Numeric Functions: The Max() Function

• Article

Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.

2008-01-29

# Compose MDX graphically

• QotD Question

2008-01-24

# Set Functions: The .AllMembers Function

• Article

Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.

2008-01-04

# MDX Numeric Functions: The Max() Function

• Article

Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.

2008-01-02

# String Functions: The .Properties Function, Part II

• Article

Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties.

2007-11-05

# String Functions: The .Properties Function

• Article

Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.

2007-09-14

# Logical Functions: IsGeneration(): Conditional Logic within Filter Exp

• Article

Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function.

2007-08-17

• Article

2007-03-16

# Logical Functions: IsAncestor(): Conditional Logic within Calculations

• Article

Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function.

2007-02-15

## Blogs

### Friend of Redgate 2020

Last week I was excited to receive an email from Redgate notifying me that...

### Azure Database for PostgreSQL

Having worked with Azure SQL Database and its many flavours for couple of years...

### Why I Support Code Automation Tools Like ORMs

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

## Forums

### Index maintenance in availability groups

By garryha

I have a 4 node always on availability group setup across two datacentres with...

### Extract part of string

hi, How can I extract part of this string declare @string varchar(1024) set @string...

### Data type conversion error

By as1981

All, This is my data flow: I'm getting the error: "Error: 0xC02020A1 at Data...

Visit the forum