5d65d756   
   From: esquel@sommarskog.se   
      
   hayko98 (vardan.hakopian@gmail.com) writes:   
   > After deleting deleting only 50000 rows i am getting this massage   
   >...   
   > Msg 8630, Level 16, State 6, Line 56   
   > Internal Query Processor Error: The query processor encountered an   
   > unexpected error during execution..   
      
   Too bad. As the message indicates, this is not really your fault, but a   
   problem in SQL Server.   
      
   Which version of SQL Server do you have, that is what does @@version   
   return?   
      
   It may help to put the result of   
      
     select trip_id from trip where due_time < @date   
      
   into a temp table and then use this table in the deletes.   
      
   Also, it is an advantage if the condition for the batching follows the   
   clustered index of the table, or else each batch could result in a table   
   scan.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)