Linked Questions

Ask Question
23 questions linked to/from Create a view that provides a list of databases
Hot Newest Score Active Unanswered
50 votes
3 answers
928 views

I think it would be useful if we could join across databases in the data-explorer. For example, I'd like to query up a list of questions that I had a hand in migrating away from SO, and see what ...
Blorgbeard's user avatar
  • 6,193
13 votes
2 answers
464 views

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....
Chris Frederick's user avatar
  • 14.8k
19 votes
0 answers
230 views

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 ...
Mechanical snail's user avatar
  • 10.3k
396 votes
2 answers
142k views

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 ...
Community wiki
26 revs, 12 users 23%
This_is_NOT_a_forum
126 votes
6 answers
29k views

The reCAPTCHAs have suddenly become almost illegible. I regularly have to change it four or five times before I find one I can read. I am tempted to just enter the known word (an easy guess), and ...
Arlen Beiler's user avatar
  • 2,037
40 votes
2 answers
7k views

Last week I was watching a TV show. During a dialog, one character asked the other something like "So how long will it take you to do it" and the answer was simply "6 to 8 weeks". ...
user avatar
39 votes
5 answers
809 views

Moderators are special, privileged users who should serve as an example to the rest of us. Therefore, it is natural to want to query behaviors and statistics about these model users, Like I did, for ...
Awesome Poodles's user avatar
  • 20.8k
50 votes
1 answer
2k views

No, this is not a question reporting pluralization bugs, I don't really care about them and I don't think they're real bugs... But, I'm very curious to know why is the Stack Exchange team ignoring ...
Online User's user avatar
  • 1,645
27 votes
3 answers
668 views

I just read a comment by user @questionto42 that one of my cross-site queries isn't working. My educated guess is this is because a special database Data.StackExchangePOC was created two days ago: (...
Glorfindel's user avatar
  • 271k
20 votes
3 answers
1k views

When doing cross-site queries on the Stack Exchange Data Explorer, two of the main problems are 1) getting the URLs right and 2) getting the site names right. For URLs, we have constructions like the ...
Glorfindel's user avatar
  • 271k
13 votes
2 answers
403 views

Today, I was running some queries on SEDE and found out that this one fails to run because of the following error: Invalid object name 'StackExchange.Codegolf_Temp.dbo.badges'. Apparently, there's a ...
Glorfindel's user avatar
  • 271k
28 votes
1 answer
527 views

I was running a query this morning similar to: create table #validaccounts(accountid int primary key) declare @sql nvarchar(max) select @sql = concat(N'insert into #validaccounts select distinct ...
rene's user avatar
  • 94.8k
7 votes
2 answers
349 views

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 ...
WinEunuuchs2Unix's user avatar
  • 569
8 votes
1 answer
366 views

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 ...
einpoklum's user avatar
  • 27.3k
6 votes
2 answers
317 views

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 ...
rene's user avatar
  • 94.8k

15 30 50 per page
1
2