Thursday, August 12, 2010
No more soup for you! - Cool SQL Error
WHERE CustomerID IN (3243,32432,324564,45645,767,....xxxx)
The number of CustomerIDs in the IN clause about 50,000.
And they were passed as input parameter.
When we tried to execute the SP, we got the following error:
Error: 8623, Severity: 16, State: 1 The query processor ran out of internal
resources and could not produce a query plan. This is a rare event and only
expected for extremely complex queries or queries that reference a very large
number of tables or partitions. Please simplify the query. If you believe you
have received this message in error, contact Customer Support Services for
It seems, that the SQL Server had a problem to compile the SP!