All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
2answers
64 views

How do I modify this query to search for specific tags?

I am forking this query, which essentially outputs the time between the question being asked and the answer being given. However, I am trying to modify the query to only search for java. I tried this: ...
2
votes
1answer
2k views

Any way to auto-format SQL in Stack Exchange Data Explorer?

One really nice feature of Toad (database administration tool) is the ability to auto-format your SQL (usually with CTRL + SHIFT + F). Manually formatting SQL greatly increases readability, but takes ...
3
votes
1answer
38 views

Problems filtering rows with Stack Exchange Data Explorer (SEDE)

I want to study how people behave where they are near to get a Tag Badge, so I need to: Extract all the ID of users who have won a Tag Badge in a certain period of time. See what Tag Badge they have ...
2
votes
1answer
74 views

Adding a text field for string input in Data Explorer

I would like to run a query that takes a textfield as an input. I know it works fine with int like so: DECLARE @UserId int = ##UserId## ... WHERE Posts.OwnerUserId = @UserId But how can I do ...
1
vote
1answer
98 views

Data Explorer query to find answers of specific user based on a keyword

I'm looking for SQL query to use within Data Explorer, to bring back all my answers (per site, from only one site at a time) with my userid and with a particular keyword, in the body of my answers. I ...
4
votes
1answer
81 views

Potential inconsistency in Stack Overflow database dump

I would like to determine on average how long it takes until a question gets its first/accepted answer. I am running this SQL query (for first answer) in data.stackexchange.com: SELECT AVG(CAST(...
8
votes
2answers
221 views

Why does data explorer not support ILIKE, SIMILAR TO, or regular expressions (~)?

Why does the data explorer not support ILIKE, SIMILAR TO, or regular expressions ~? Talking to the devs: Would it be possible to add that functionality?
-4
votes
2answers
927 views

Allow some basic HTML formating inside query results or interpret MarkDown

I wrote this query and Markdown inside third column wasn't converted to HTML. So I converted the closes reasons to HTML and it appears that the Javascript doesn't make the rows look parsed. As there ...
5
votes
2answers
104 views

How to use Data Explorer to find the most prolific closers on a site?

Goal: Make the list of Top 50 users who closed most questions on a site. This means the questions that actually got closed, not pending close votes/flags. Deleted questions are excluded from ...
3
votes
2answers
96 views

How I can get questions where the body is the same as the title?

It is know that many questions have the same body and title, So I wanted to create a query to show them all, but this don't work : select Posts.id as [Post Link], -- Question title. Count(...
2
votes
1answer
74 views

How to count the most frequent CloseReasonTypes per posts in the data-explorer?

I started to compose this query and I find it's difficult to see why the question should be closed. select TOP ##Limit:int?38369## -- The maximum value the hardware can handle. Posts.Id as [...
2
votes
1answer
109 views

Querying for reputation of the commenter and its addressee using SEDE

How can I modify this Data Explorer query for the case when user of the comment is same as the poster, then the query should look for the tagged user in the comment and print the tagged user ...
0
votes
1answer
88 views

Querying for name and rep of commenter and post OP using SEDE

I am new to T-SQL and would greatly appreciate help on the following query on the Stack Exchange Data Explorer. For a given comment I need to display the username and reputation of whoever posted the ...
19
votes
0answers
167 views

Data Explorer execution plans are no longer available because SHOWPLAN permission is denied [closed]

I noticed after a recent maintenance downtime that now I get the following message when trying to include an execution plan with a query: SHOWPLAN permission denied in database 'StackOverflow'. ...
5
votes
1answer
83 views

Why does the data explorer have inaccessible columns?

Why does the data explorer have columns that do not return visible results? For example, the column Votes.UserId does not return any information. This makes sense to me. I just don't understand why ...
4
votes
1answer
140 views

Trouble with fetching data

I'm trying to query the following data from stackexchange: Fetch all the questions asked about Android, in past five years, and display post's id (a.iD), associated tags (a.Tags), for the person ...
4
votes
1answer
589 views

SQL Query not returning hyperlink on data.stackexchange.com

I am basically a C programmer but I started on SQL today with the only purpose of fiddling around the data available on data.stackexchange.com. So please bear with me if my question is naive or ...
10
votes
2answers
286 views

A query to get all posts that count for Archaeologist and Excavator

I've been playing with data-explorer to peruse stackoverflow more and learn some t-sql. I managed to write this query, which lists out all posts the user has edited and then shows a difference in ...
4
votes
2answers
111 views

Stack Exchange Data Queries - Get URL of Site Query Ran Against

I've made myself a little query on the stack exchange data explorer which gets a leader board for the top comments on the site, and the URL for the post that the comment was posted on. This query ...
3
votes
1answer
116 views

Links to all my questions?

Is there a way to get hold of a parsable list of links (or if that's not possible, IDs) to all my questions to all my answers preferably without using the data dump?
53
votes
15answers
2k views

Can we become our own “Northwind” for teaching SQL / databases?

In the Microsoft ecosystem there are some standard databases like Northwind ... The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, ...