Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
AS2005 Usage-Based Optimization Wizard Error
0 views
Skip to first unread message
Keith Spitz
May 30, 2007, 12:49:01 PM5/30/07
to
I am trying to use the Usage-Based Optimization Wizard on one partition of
one of the cubes in my AS2005 database. I select the partition, click
"Next"; accept the default criteria by clicking "Next"; then, in the "Review
the Queries that will be Optimized" screen. I get the error below. Anyone
have any suggestions?
one of the cubes in my AS2005 database. I select the partition, click
"Next"; accept the default criteria by clicking "Next"; then, in the "Review
the Queries that will be Optimized" screen. I get the error below. Anyone
have any suggestions?
Thanks!
Keith Spitz
Wall Street On Demand, Inc.
TITLE: Microsoft SQL Server
------------------------------
This wizard will close because it encountered the following error:
------------------------------
ADDITIONAL INFORMATION:
Warning: The query processor could not produce a query plan from the
optimizer because the total length of all the columns in the GROUP BY or
ORDER BY clause exceeds 8000 bytes. Resubmit your query without the ROBUST
PLAN hint. (Microsoft SQL Native Client)
0 new messages