"This is a rare event"
-
I believe SQL Server has a maximum query memory of 2 gigs. You obviously surpassed that with all the unions. I believe all unions are read into memory. I am guessing here, I could be wrong.
-
For giggles I programmatically created a query that had a huge number of unions. The full message from SQL Server was:
Quote:
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.
:laugh:
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a DomainThere are also only 100 levels of recursion in a cursor. Found that out in the poast two weeks when a client's process failed on a stored procedure that was last edited a decade ago.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
-
There are also only 100 levels of recursion in a cursor. Found that out in the poast two weeks when a client's process failed on a stored procedure that was last edited a decade ago.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
Or a recursive CTE, but you can increase that I think.
-
For giggles I programmatically created a query that had a huge number of unions. The full message from SQL Server was:
Quote:
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.
:laugh:
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a DomainI never make a large JOIN , I split it up:
A JOIN B JOIN C JOIN Dbecomes:( ( A JOIN B ) JOIN C ) JOIN D -
I never make a large JOIN , I split it up:
A JOIN B JOIN C JOIN Dbecomes:( ( A JOIN B ) JOIN C ) JOIN DOh that's interesting! I'll have to try that!
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a Domain -
For giggles I programmatically created a query that had a huge number of unions. The full message from SQL Server was:
Quote:
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.
:laugh:
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a Domain -
Oh that's interesting! I'll have to try that!
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a DomainFor inner joins the optimizer will disregard any order of the joins, or any parentheses for that matter. If you want to force a specific order there's a hint for that:
OPTION (FORCE ORDER)For outer joins this is not the case, they will happen in the relative order specified.Wrong is evil and must be defeated. - Jeff Ello
-
I never make a large JOIN , I split it up:
A JOIN B JOIN C JOIN Dbecomes:( ( A JOIN B ) JOIN C ) JOIN DQuestion for you? Can you verify this 1) uses less memory and/or 2) improves performance time? Thanks! Craig
-
Question for you? Can you verify this 1) uses less memory and/or 2) improves performance time? Thanks! Craig
It has significantly reduced execution time in many cases. Your mileage will vary.
-
This message is only shown to the SELECT few...
That's bang out of ORDER ;P
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
-
For giggles I programmatically created a query that had a huge number of unions. The full message from SQL Server was:
Quote:
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.
:laugh:
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a DomainWhat version of SQL was that? What was the count of unions that caused this? Thank you.
-
For giggles I programmatically created a query that had a huge number of unions. The full message from SQL Server was:
Quote:
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.
:laugh:
Latest Article:
Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a DomainWhich means "Stop doing this to us in here!" :mad: Just for more gig-gles, sent it over and over and see is the "rare event" message changes.
