The query processor ran out of stack space during query optimization. Please simplify the query.

10-14-08, 10:48 AM

Waldy

How can I delete some rows from a database when I get the above error?

It is a simple delete from table where column = value type statement.

10-14-08, 10:54 AM

dave ballantyne

Waldy wrote:
> How can I delete some rows from a database when I get the above error?
>
> It is a simple delete from table where column = value type statement.
>Are you up to date on service packs ?

Seems like a fix here, http://support.microsoft.com/default.aspx/kb/945896

Dave

10-14-08, 12:12 PM

Waldy

"dave ballantyne" <symlink> wrote in message
news:4996
> Seems like a fix here, [..]

I just installed that, but it made no difference.

10-14-08, 12:48 PM

dave ballantyne

Waldy wrote:
> "dave ballantyne" <symlink> wrote in message
> news:4996
>> Seems like a fix here, [..]
>
> I just installed that, but it made no difference.
>

In that case, please post the query and DDL

10-14-08, 02:03 PM

Waldy

"dave ballantyne" <symlink> wrote in message
news:5660
> In that case, please post the query and DDL

Hi Dave,
it's not a query. It's just a simple delete statement

delete from table where column = value

There are about a dozen foreign keys and the same number of constraints on
the table. I can only guess that it's something to do with that.

10-14-08, 02:36 PM

dave ballantyne

Waldy wrote:
> "dave ballantyne" <symlink> wrote in message
> news:5660
>> In that case, please post the query and DDL
>
> Hi Dave,
> it's not a query. It's just a simple delete statement
>
> delete from table where column = value
>
> There are about a dozen foreign keys and the same number of constraints on
> the table. I can only guess that it's something to do with that.
>
Try creating a copy , then dropping the constraints one by one until it
works.

Then post the DDL to create the table and the remaining constraints/keys
/ indexes. Then you may well be able to get some better targetted help

Dave

10-14-08, 03:50 PM

Waldy

Is there any way to turn off query optimization?

10-14-08, 04:11 PM

dave ballantyne

Waldy wrote:
> Is there any way to turn off query optimization?
>No , every query gets optimized. Its a very integral thing.

Once you find what is causing the error , you will be able to workaround
it ....

10-14-08, 11:07 PM

Gert-Jan Strik

Waldy wrote:
>
> How can I delete some rows from a database when I get the above error?
>
> It is a simple delete from table where column = value type statement.

Have you checked that "table" is actually a table and not a view?

Do you get a query plan (and not an error) if you change "delete" to
"SELECT *"?

Similar Threads
The query processor ran out of stack space during query optimization. Please simplify the query. Hi there, I get the error above when I try to step into a SQL Server 2005 stored procedure using BIDS. The procedure runs OK when you execute it. Does anyone know why this...
Simple SQL generates: Internal Query Processor Error: The query processor could not produce a query plan. I get this error on a very simple stored procedure that is just doing an insert into a 4 column table on SQL Server 2005 Msg 8624, Level 16, State 1,...
Error message code 8621 : The query processor ran out of stack space during query optimization Hi, I'm facing problem with sql request with SQL Server 2005. I have a 3-tier architecture. I'm using a web application running under Tomcat and storing data in SQL Server....
SQL Server 2005 -- Internal Query Processor Error: The query processor could not produce a query plan Hi all I migrated a database from SQLServer 2000 (Standard edition) to SQLServer 2005, standard, SP1, on Windows XP Prof, SP3 After migration I get the following...
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information Hi All, We have a problem with a query that after using it for some months without any problem suddenly throws a error : Internal Query Processor Error: The query processor...