HELP!!! - Problem with hints...

19 Jul 2006 3:44 PM

segis bata

Hello everyone,

I'm having this problem, I'm trying to run a query that consists of six
tables and one view (all joined together)

When I run it without anything on the where (or just one criteria in the
where clause) works just fine, but if I run it with two criteria in the
where clause I get the following message:

<<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
larger than the page size into a hash table. Resubmit the query with the
ROBUST PLAN hint. >>>

And when I do so -adding the ROBUST PLAN option-, I get the following
message:

<<< 'Query hints' cannot be used in this query type. >>>

Any idea what is going on?!? please let me know!!!

TIA,
sb-r

19 Jul 2006 3:48 PM

segis bata

Everyone,

I forgot to put this...

I'm using SQL Server 2000 on Win2003 Server, SP 1

Thanks again...

Show quote

"segis bata" <segisb***@hotmail.com> wrote in message
news:exo1vo0qGHA.4192@TK2MSFTNGP04.phx.gbl...
> Hello everyone,
>
> I'm having this problem, I'm trying to run a query that consists of six
> tables and one view (all joined together)
>
> When I run it without anything on the where (or just one criteria in the
> where clause) works just fine, but if I run it with two criteria in the
> where clause I get the following message:
>
> <<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
> larger than the page size into a hash table. Resubmit the query with the
> ROBUST PLAN hint. >>>
>
> And when I do so -adding the ROBUST PLAN option-, I get the following
> message:
>
> <<< 'Query hints' cannot be used in this query type. >>>
>
> Any idea what is going on?!? please let me know!!!
>
> TIA,
> sb-r
>

19 Jul 2006 10:03 PM

Erland Sommarskog

segis bata (segisb***@hotmail.com) writes:
Show quote

> I'm having this problem, I'm trying to run a query that consists of six
> tables and one view (all joined together)
>
> When I run it without anything on the where (or just one criteria in the
> where clause) works just fine, but if I run it with two criteria in the
> where clause I get the following message:
>
><<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
> larger than the page size into a hash table. Resubmit the query with the
> ROBUST PLAN hint. >>>
>
> And when I do so -adding the ROBUST PLAN option-, I get the following
> message:
>
><<< 'Query hints' cannot be used in this query type. >>>
>
> Any idea what is going on?!? please let me know!!!

Sounds like you are in dire straits. But at least you could post the
query you are having problem with.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

26 Jul 2006 1:57 PM

Steve G

What happen if you try the query without the view in it? with and without the
robust plan in the query.

Show quote

"segis bata" wrote:

> Hello everyone,
>
> I'm having this problem, I'm trying to run a query that consists of six
> tables and one view (all joined together)
>
> When I run it without anything on the where (or just one criteria in the
> where clause) works just fine, but if I run it with two criteria in the
> where clause I get the following message:
>
> <<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
> larger than the page size into a hash table. Resubmit the query with the
> ROBUST PLAN hint. >>>
>
> And when I do so -adding the ROBUST PLAN option-, I get the following
> message:
>
> <<< 'Query hints' cannot be used in this query type. >>>
>
> Any idea what is going on?!? please let me know!!!
>
> TIA,
> sb-r
>
>
>