Physical Setup: SQL Server 2005 Enterprise Ed, 32 Bit. 3 GB switch
enabled.

We are having very annoying processing errors. Dimensions process just
fine. When we process partitions, we are able to process without a
problem using Process Data option. When we attempt Process Index option
to build indexes and aggregations, we get the following error...

Errors and Warnings from Response
Memory error: The operation cannot be completed because the memory
quota estimate (2904MB) exceeds the available system memory (1996MB).

We have tried smaller partitions, and have to get ridiculously small to
get Process Index to run.

We really need the indexes for query performance. Anyone have any ideas?