×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

Here is the MSDN explanation,but I don't think it applies to my situation.

yadocld(yadocld)
Error 8621
Severity Level 16
Message Text
Internal Query Processor Error: The query processor ran out of stack space during query optimization.

Explanation
The Query Processor is using a large but limited memory stack when optimizing queries. In some extreme situations the stack size may become a limit for a given very large query--for example, a query containing an inlist with 100,000 constants.

Action
Simplify the query to avoid this problem. For example, in the case of an extremely large inlist use temporary table or table variable to store the constants, and rewrite the query to use this variable or temporary table instead.
(#756038@0)
Last Updated: 2002-9-19
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 请问这个ADO Error Message 如何解决？ -yadocld(yadocld); 2002-9-19 {299} (#755996@0)
    在ASP中我用了如下：
    sqlFolder="INSERT INTO Folders (...) VALUE (...) "
    Conn.execute(sqlFolder)
    在大部分时候，可以正确执行，但有些时候（未知）会返回以下Error Message:
    Internal Query Processor Error: The query processor ran out of stack space during query optimization.
    数据库是：SQLServer2000
    • don't know. did you try to search on google by this error message? sounds like you SQL server has some configuaration problem. -ningxin0809(雁影行洲); 2002-9-19 (#756021@0)
      • Here is the MSDN explanation,but I don't think it applies to my situation. -yadocld(yadocld); 2002-9-19 {646} (#756038@0)
        Error 8621
        Severity Level 16
        Message Text
        Internal Query Processor Error: The query processor ran out of stack space during query optimization.

        Explanation
        The Query Processor is using a large but limited memory stack when optimizing queries. In some extreme situations the stack size may become a limit for a given very large query--for example, a query containing an inlist with 100,000 constants.

        Action
        Simplify the query to avoid this problem. For example, in the case of an extremely large inlist use temporary table or table variable to store the constants, and rewrite the query to use this variable or temporary table instead.
        • as I understood it is. I didn't know much about stack. but a DBA will. -ningxin0809(雁影行洲); 2002-9-19 (#756041@0)
    • maybe something wrong in your SQL server configuration? -reed(芦苇); 2002-9-19 (#756042@0)
      • think so -ningxin0809(雁影行洲); 2002-9-19 (#756045@0)
      • is there anybody know how to config the database to avoid this problem? -yadocld(yadocld); 2002-9-19 {310} (#756060@0)
        it really bothers me, because in most time it won't happen, but sometime it jumps out. I don't know how to handle it since I am just a programmer and we don't have a DBA here. and as my opion, sqlserver is like a silly DB don't need administration at all if not caring about the efficiency and performence.
        • 1. Apply the latest service pack (sp2) to your database server. 2. Check your memory setting and allocate more memory to your sql service. 3. Check the size of your tempdb partition. -yangn(Raymond); 2002-9-19 (#756375@0)
          • Thank you very much, I will try it. -yadocld(yadocld); 2002-9-20 (#757889@0)
          • the tempdb filesize is set to automatic grow. and unrestricted file size,is that ok? -yadocld(yadocld); 2002-9-20 (#757897@0)
            • 有时查询过大的话TEMP空间也会满的,最好的做法是估计可能需要的空间,然后设置成自动的就可以了 -antmm(xiao ant); 2002-9-20 (#758220@0)
            • tempdb只有在一种情况下才会满，就是其所在的partition或logical drive再没有可分配的自由空间。很多公司在dba缺乏的情况下常把tempdb放在default location (master data 所在的location),这是很要不得的。 -yangn(Raymond); 2002-9-20 {127} (#758821@0)
              tempdb should be on the dedicated partition with RAID 1 configuration. and the size should be set up as "automatically grow".
    • 不知道2000的结构如何,如果是7.0的话,可能是日志满了,或者是TEMP空间满了 -antmm(xiao ant); 2002-9-19 (#756051@0)
    • You could be running a huge query, trying to do a huge aggregation function, or sorting a huge set of data -handd(handd); 2002-9-19 (#756316@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论