Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with discussion
Search options not deleted
user 26837
Questions that may not necessarily have a clear-cut right or wrong answer and are often subjective. If your question isn't a bug report, feature request, or request for support, it's probably a discussion.
49
votes
3
answers
2k
views
Why have so many users given '1920' as the year of birth? [closed]
When I started data mining the StackOverflow database, I found a surprising number of users had set their birthday in a way that made them 89 years old.
I blogged about it and gave a full list of th …
- 2,099
26
votes
Accepted
SO database schema
Not the whole schema, but we've documented the contents of the database export schema.
Here's how to import the database dump into SQL Server, which includes table creation statements. I explain how …
- 2,099
15
votes
Is the fastest gun in the west solved?
Let's look at whether it's really a problem. To find out, we need to focus on questions that:
Have more than one submitted answer
Have one accepted answer
Have not been closed
Other answers haven't …
- 2,099
12
votes
Accepted
Stackoverflow data dump sites?
I created SPWho2.com, a statistics analysis dump for Stack Overflow. I built it so that I can throw in the database dumps for Server Fault and Super User when those become available too.
I'm super-a …
- 2,099
9
votes
Accepted
The real SO database schema (not public dump)
You've got two questions in there.
First, is there any way to see the real schema? Answer: not now, but I'd question why you needed it. If you had a really good reason and you explained that to the …
- 2,099
9
votes
DevDays 2009 Reviews - San Francisco
From my blog entry about DevDays:
I didn't know what to expect from StackOverflow DevDays, and I was pleasantly surprised.
In a nutshell, the presenters showed the basics of several different progra …
- 2,099
8
votes
Accepted
Behind the curtain
Jeff and Jarrod posted self-deprecating answers, but as an outsider, let me tell you that the database code and schema are really tight. (And I should add that has absolutely nothing to do with me, h …
- 2,099
3
votes
Trilogy Database Design
There's different databases per site. Generally speaking, if you're not talking about rolling out thousands of sites, it's easier this way for scalability purposes. Makes it easier to split the data …
- 2,099
5
votes
SE Post Data Compressed?
This answer is a little trickier than Robert implies in his answer.
SQL Server 2008 introduced data compression as a feature in Enterprise Edition. Pages are compressed before they're written to dis …
- 2,099
8
votes
Are people too miserly with up votes?
This was one of the questions I explored at SPWho2.com:
What kinds of questioners do the most upvoting?
Or in other words, what tags are the friendliest? Are people who ask questions with a particu …
- 2,099
3
votes
Accepted
How does SO store temporary users in database?
You've got two questions in here, so I'll answer each individually:
My question is how can I attach the
question to the right user?
There's only one Users table in each Creative Commons dump. …
- 2,099
2
votes
Public-Facing Interactive Data-Dump
I've got a publicly accessible SQL Server with the dumps from ServerFault, StackOverflow, SuperUser, and Meta. Connection info is here:
http://www.brentozar.com/archive/2010/02/querying-the-stackove …
- 2,099