Reputation
4,466
Next tag badge:
121/100 score
16/20 answers
Badges
4 24 59
Newest
 Caucus
Impact
~571k people reached

Jul
28
comment
What's your opinion on taking out trash, washing dishes, doing windows, vacuuming, sweeping, mopping and washing down the blackboards? ;-) That's what the moderators do. Nothing glitzy or glamarous.
Jul
28
comment
It's also worth noting that just because someone flagged it out of the pool does not mean they did so well, and having an after-hours, so to speak, moderator would be excellent for the team.
Jul
27
awarded  Caucus
Jul
20
comment COUNT number of column values with INNER JOIN
I'm voting to close this question as off-topic because answered at stackoverflow.com/q/31514856/939860
Jun
22
revised Handle Duplicate entries in Fact table in Data Cube
added 128 characters in body
Jun
19
comment Identical query slower when searching for `T` rather than `F`
Guys, if we aren't gonna get an answer shortly can we move this to chat? It's a great question, to be sure, but it's a little long in the tooth here.
Jun
19
comment Handle Duplicate entries in Fact table in Data Cube
The question is still a little vague. Can you provide some better details? Maybe give us some sample data to work with, using the likes of sqlfiddle?
Jun
18
comment Is it secure to set default value for password field?
@Colin'tHart it's just not well formatted for that site, it's too generic and the tone isn't right.
Mar
20
comment how to check and list all the files related to mongodb in ubuntu? I am looking for config files, password informations for mongodb
There is no need to delete the question. Welcome to dba.se!
Mar
20
comment how to check and list all the files related to mongodb in ubuntu? I am looking for config files, password informations for mongodb
I'm voting to close this question as off-topic because this question is inappropriate for dba.se
Mar
2
comment What is a Key/Value store database?
The fact that there are often only two (or three, or a few more, depending on the metadata involved) columns instead of a massive number of columns, and the types are often fixed. There's no reason NOT to create a KVP store in a traditional RDBMS, except that it's basically schemaless.
Feb
11
awarded  Nice Question
Jan
5
awarded  Yearling
Dec
8
awarded  Popular Question
Nov
3
awarded  Good Question
Oct
25
comment Don't know how to transform variable entity into relational table
I would also suggest that breed is an attribute that all animals share, just in different ways.
Oct
21
comment Retrieving month from date field in my database
@Serg how often do you find yourself writing queries to do things that have no user interaction? What if the user were able to supply a given month and year, instead of us taking the current month and year from curdate()? I think that we should contemplate how to provide a parameterized query to find the data the user wants, and then as Aaron indicated, help the user figure out how to apply indexes to best give us the data quickly, so we don't have to do table scans.
Oct
21
comment Retrieving month from date field in my database
@Serg you may want to re-read the question and contemplate your answer, and possibly give more details on how this would be used, and what the value you've done above actually does in response to a UI selection of month and date.
Oct
21
comment Retrieving month from date field in my database
@ypercube sure it does. It just doesn't let the user select the actual month they want. What OP needs is a clear stored procedure that does basic TSQL (which means this is an SO Q) but what this answer offers is a RAD approach designed to indicate quickly in a demo how the product should work and as such I consider the informality of this post quite the avant garde expression for how little effort would go into such a query. I can definitely understand the delicate cycle of decision that led to this new poster on our site sharing such a simple selection, and allowing us to infer the obvious
Oct
17
awarded  Popular Question