Reputation
588
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 23
Newest
 Caucus
Impact
~61k people reached

May
14
comment
SE are trialling an alternative way of asking the candidates questions: please see this meta question ………………………………………………………………………………………………………………………………… There are varying opinions on what is wrong with StackOverflow. Can you be more specific on what problems you see with it, and what you would do to deal with them or prevent them from happening on DBA.SE?
May
14
awarded  Caucus
May
2
awarded  Notable Question
Nov
27
awarded  Popular Question
Nov
1
awarded  Yearling
Oct
17
accepted How do I create a user-defined aggregate function?
Apr
30
revised How do I create a user-defined aggregate function?
added 42 characters in body
Apr
30
comment How do I create a user-defined aggregate function?
Cool math, but I actually wanted to know how to create an aggregate function in general. product was just supposed to be one example of several.
Apr
30
revised How do you query supertypes to get subtype data?
formatting -- align outlines of tables
Apr
30
suggested approved edit on How do you query supertypes to get subtype data?
Apr
30
revised How do I create a user-defined aggregate function?
added 401 characters in body
Apr
30
answered What is a common way to save 'debit' and 'credit' information?
Apr
30
asked How do I create a user-defined aggregate function?
Apr
26
comment MySQL: A better way to write this query?
The thing that really stands out to me is the tablescan (type = ALL in the explain output) on submission. So either you don't have a suitable index for submission.submitted, or MySQL estimates that a large enough percentage of rows will pass through the filter that it's cheaper to just do a tablescan.
Apr
24
comment MySQL Character set and Collation Issue.?
I assume you're running these queries from the terminal. It may be possible that the data and the database are fine, but your terminal isn't reading and displaying the characters properly.
Apr
24
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
MySQL does allow that -- see column_definition.
Apr
23
awarded  Commentator
Apr
23
comment Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
@Nir what do you mean by large -- lots of rows or lots of tables? You'll have to make one change for each table, regardless of number of rows. If you're only dumping one table, then you have to make one change.
Apr
23
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
Yes; it doesn't seem to help, though.
Apr
23
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
Perhaps this is a non-repeatable phenomenon, i.e. it will only happen with my specific hardware/configuration.