Prev: Editing Maintenance Plans in SQL 2005
Next: Event 833
From: Hess on 19 Apr 2006 12:30
Folks,

I am getting the follwoing error:

"cannot sort a row of size 8192, which is greater than the allowable
maximum of 8094" .

Doing the research around the web, I found a solution which had be
using Option "Robust Plan" as a part of the query.

I am getting another error "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."

Am i missing something.

- Jess

From: Gert-Jan Strik on 19 Apr 2006 13:58
Have you calculated how much bytes the arguments in the GROUP BY and/or
ORDER BY clause need? If it exceeds 8094 bytes, then it will simply not
work, regardless of the ROBUST PLAN option.

When in doubt, then please post the query and relevant DDL.

HTH,
Gert-Jan


Hess wrote:
>
> Folks,
>
> I am getting the follwoing error:
>
> "cannot sort a row of size 8192, which is greater than the allowable
> maximum of 8094" .
>
> Doing the research around the web, I found a solution which had be
> using Option "Robust Plan" as a part of the query.
>
> I am getting another error "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."
>
> Am i missing something.
>
> - Jess
 | 
Pages: 1
Prev: Editing Maintenance Plans in SQL 2005
Next: Event 833