Data Explorer (SEDE)

« first day (2096 days earlier) ← previous day next day → last day (9 days later) »

4:18 PM

I have publicly documented `dbo.sede_ineachdb`:
https://meta.stackexchange.com/a/399304/165455

I posted it as a new answer because it's way too much documentation to add to the existing answer, and it really is a different solution.

Would love help getting these all coalesced:

A: Allow cross-site queries in data explorer

Here's an improved cross-site version. Performs up to 2 times faster. Uses newer TSQL features for shorter, easier to understand code. Gives more natural site names. Provides https URL's. Catches the oversight with StackExchange.Audio.Meta. See the query in SEDE. Or here's the code: /*-- INSTRU...

Q: How can I write a cross-site Data Explorer query that joins databases on linked accounts?

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.Exported]..[Users] u1 INNER JOIN [ServerFault.Exported]..[Users] u2 ON u1.Id = u2.Id I had assum...

Q: Directly support cross-site queries in the Data Explorer

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 would join on the network-wide user ID, across the tables corresponding to all the sites. (Doing ...