Questions tagged [stack-exchange-data-explorer]

The Stack Exchange Data Explorer is an open source tool for running arbitrary queries against public data from the Stack Exchange network. Features include collaborative query editing for all graduated and public beta Stack Exchange sites.

Filter by
Sorted by
Tagged with
0 votes
1 answer
24 views

Why does my stackexchange post not produce all rows?

Here is my code that I use over here - https://data.stackexchange.com/stackoverflow/query/edit/1603630 SELECT title,concat('https://stackoverflow.com/questions/',id), tags, score, creationDate From ...
desert_ranger's user avatar
3 votes
1 answer
1k views

What are the benefits of using XML over CSV files in regards to data dumps? [closed]

Prologue I've noticed that one benefit of using CSV over XML for data dumps is the fact that fewer disk space is used. See minimal working example below. Let's suppose we have the following dataset. ...
rdrg109's user avatar
  • 131
1 vote
1 answer
186 views

Which system catalog view has the create_date of a database which name was modified?

In the Stack Exchange Data Explorer each Sunday all databases are dropped and recreated one by one with this stored procedure. For each database the script starts with (paraphrased) for example Dba....
rene's user avatar
  • 150
11 votes
1 answer
5k views

What does double number sign ## mean in SQL?

A meta post gives a nice snippet of SQL declare @search nvarchar(max) = ##searchfor:string?carefully %listen## select id [Post Link] , score , creationdate , lastactivitydate , ...
WXJ96163's user avatar
  • 281
1 vote
1 answer
160 views

What is the difference between *data dictionary* and *data dump of SEDE*?

A meta post (https://meta.stackexchange.com/q/2677/714660) gives the "anatomy" of the data dump from SEDE that includes the structure of the public data dump(tables, columns, data types, etc) and ...
WXJ96163's user avatar
  • 281