All Questions
Tagged with support data-explorer
702
questions
2
votes
1
answer
48
views
How can I search for tags with that include a specified string in their Usage Guidance?
I would like to search for all tags (on Stack Overflow) that include some specific string in the Usage Guidance portion of their Tag Wiki. How can I do that?
Specifically I would like to search for ...
GlorfindelMod
- 253k
9
votes
1
answer
149
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
- 15.2k
2
votes
2
answers
197
views
How to run a Stack Exchange data query with the Stack Exchange API
I'm trying to find out if there is a way to run a query/complex search on the Stack Exchange API.
I need to find all users that have a reputation greater than 250 and are from a certain location. I ...
- 38.9k
-5
votes
0
answers
136
views
How can I run SEDE queries on my computer? [duplicate]
Some SEDE queries time out on SEDE. How can I run SEDE queries on my computer?
- 41.3k
7
votes
2
answers
249
views
Data Explorer Query crashes with collation conflict error
I have a website built off my Q & A posted in Stack Exchange sites such as; Ask Ubuntu, Stack Overflow, SE Security, etc.
Data Explorer is used to scrape ALL Stack Exchange Q & A I've posted ...
- 8,262
12
votes
1
answer
332
views
What are the indices used in SEDE?
I'm writing an application that uses the Stack Exchange Data Dump. I've imported the most recent dump into SQL Server 2014 on my local development machine.
I wrote a query that runs very slowly on my ...
CommunityBot
- 1
6
votes
2
answers
245
views
How long does the Data Explorer Refresh take for each database?
Each Sunday at 03:00 UTC the Stack Exchange Data Explorer gets refreshed. It takes 6 to 8 hours to refresh all 350+ databases that hold the Posts, Votes, History etc for the Main and Meta sites.
I was ...
- 473
382
votes
2
answers
124k
views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...
- 26.8k
7
votes
2
answers
125
views
How should I go about retrieving the date of when a question became/was no longer hot with SEDE?
I am currently making a SEDE query to determine which questions from a specific user have made it onto the Hot Network Questions list and when. While I can get the specific questions, I am unable to ...
GlorfindelMod
- 253k
-1
votes
1
answer
120
views
Data explorer query takes a lot of time and needs to be optimized
This is a Stack Exchange Data Explorer query which gets the top users on specific skill scores (example: JavaScript) based on a specific country (example: Egypt), and it took a lot of time until it ...
- 6,675
19
votes
0
answers
222
views
Directly support cross-site queries in the Data Explorer [duplicate]
Often you want to query some statistic for a user across all sites. For example, you might write a query to find your rejected suggested edits across all Stack Exchange sites.
To implement this, you ...
Aaron BertrandStaff
- 42.8k
13
votes
2
answers
409
views
How can I write a cross-site Data Explorer query that joins databases on linked accounts? [duplicate]
The answer to this question implies that you can write cross-site Data Explorer queries, but the sample query doesn't appear to do what I think it should.
SELECT TOP 1 *
FROM [StackOverflow....
Aaron BertrandStaff
- 42.8k
5
votes
1
answer
163
views
How can one see when a query was cached in SEDE?
Query results in SEDE are cached:
How can one see when a query result was last cached in SEDE?
Aaron BertrandStaff
- 42.8k
5
votes
1
answer
101
views
Are SEDE results ever cached on client side, or solely on server side?
I know that SEDE query results are cached on the server side. I wonder if in some cases they are also cached on the client side.
- 26.8k
4
votes
3
answers
268
views
How can I avoid the Data Explorer cache?
In Stack Exchange Data Explorer, I noticed that after a query is executed, it is stored in the cache (I think). How do I disable this feature?
For example, when I run this query, it should generate a ...
- 26.8k