Re: Getting info from SQL DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This is the error:
system.data.sqlclient.sqlexception: Internal query processor error:
The query processor ran out of stack space during query optimization

This is because the in clause would have 30,000+ items in it.

On Apr 25, 1:53 pm, "Armin Zingler" <az.nos...@xxxxxxxxxx> wrote:
"Bill Schanks" <wscha...@xxxxxxxxx> schrieb

The error is coming because sSQL is too large, and I am getting the
error on SQL Excecution when there are 30000 entries in the in clause
of the sql command.

Reading this statement

Howerver on a large number of listview records this will produce a
problem (Say if I had 30,000 Listview entires)."

I thought it takes too long.

What does "SQL is too large" mean? Do you get an exception? Which one?

Armin

.

Relevant Pages

  • Re: Duplicates in large table
    ... proper where clause will allow the query processor to use statistics, ...
    (microsoft.public.sqlserver.programming)
  • Re: Order By or Dataview sort quickest?
    ... faster if the query processor can use that index (remember, ... cardinality of the tables and indexing you've done affect ... > Anyone know which operation is faster, an Order By clause in the Select ... > statement against an SQLCE db, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Getting info from SQL DB
    ... The query processor ran out of stack space during query optimization ... I'm surprised you could go as high as 30,000, that's a pretty big IN clause. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Getting info from SQL DB
    ... The query processor ran out of stack space during query optimization ... This is because the in clause would have 30,000+ items in it. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Server: Msg 8642: The query processor could not start the necessary thread resou
    ... What version of SQL Server? ... the query processor to use a serial plan for this query. ... Microsoft SQL Support ... | The query processor could not start the necessary thread ...
    (microsoft.public.sqlserver.setup)