I run the following query on SEDE. SELECT postID [Post Link], Score, Text FROM Comments WHERE Score > 0 ORDER BY Score Desc This is a very simple and basic query to find the highly voted comments. IT gives the following error. Line 1: The query processor ran out of internal resources and co...

In my answer on Out-of-resources when trying to run a popular DataExplorer query I explain why you get that error despite SEDE / SQL Server giving the impression you run a simple query. Applying what I explain in my answer on MSE to your specific case with the goal to not have SQL Server bark thi...

So, I tried to run this query Users with highest Socratic progress (socratic hopefuls) which has many views (so I assume it's popular), but I get a message saying: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected fo...

The use of a magic column like [User Link] in a query doesn't involve real magic but actually very hard work for the query plan processor. This is what happens in the SEDE internals. Once the maximum of 50,000 rows are read from the SqlDataReader in PopulateResults the results are post-processed ...