« first day (2506 days earlier)      last day (303 days later) » 

2:16 PM
-16
Q: SEDE cannot handle very basic query to show all comments with scores greater than zero

President of Foolish PeopleI 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...

2
A: SEDE cannot handle very basic query to show all comments with scores greater than zero

reneIn 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...

8
Q: Out-of-resources when trying to run a popular DataExplorer query

einpoklumSo, 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...

10
A: Out-of-resources when trying to run a popular DataExplorer query

reneThe 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 ...

> 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.
 
 
8 hours later…
10:18 PM
6
Q: Planned SEDE maintenance scheduled for Oct 15, 2021 and Oct 16, 2021 15:00-17:00 UTC (11a-1pm ET)

Tom LimoncelliDue to ongoing planned network upgrades, data.stackexchange.com (a.k.a. SEDE or the Stack Exchange Data Explorer) may be unavailable for up to 2 hours on Friday and Saturday morning this week. Likely considerably less. Friday, Oct 15, 15:00-17:00 UTC (11am-1pm ET) Saturday, Oct 16, 15:00-17:00 ...

 

« first day (2506 days earlier)      last day (303 days later) »