Reputation
5,711
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
10 27
Newest
 Custodian
Impact
~271k people reached

Oct
18
comment How do I create a user-defined aggregate function?
Either C or C++. Not SQL, anyway.
Oct
11
answered Does my table violate normalization rules?
Oct
11
revised Is there a reason to use extremely abbreviated table names?
Spelling.
Oct
11
comment How to add the aliases to the group by clause
In standard SQL, the dbms is supposed to act like it evaluates the SELECT clause after the GROUP BY clause. That's why the GROUP BY clause can't see aliases in the SELECT clause--they haven't been evaluated (created) yet. I like common table expressions for reducing complexity like this.
Oct
7
awarded  Tag Editor
Oct
7
revised
added 145 characters in body
Oct
6
wiki
Oct
6
suggested approved edit on
Oct
6
revised Splitting a database into multiple databases
edited tags
Oct
6
answered Splitting a database into multiple databases
Oct
4
comment Is the speed of a PostgreSQL SELECT adversely affected by too many indexes on the table?
Usually, when someone says lots of indexes hurt performance, they're talking about insert, update, and delete statements. In short, anything that requires changing the indexes in addition to changing the tables.
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
@ack__: No, I don't know of more recent products. It's been ages since I've worked for a place that invested in CASE software.
Sep
23
answered Is there a tool to check if my database is normalized to the third normal form?
Sep
12
comment What is the purpose of the keyword “ID” in PostgreSQL?
It acts as if your GUI tool passed an uppercase column name, including double quotes, to PostgreSQL. (Other things might account for this behavior, but this is the most common one in my experience.) Any time you create a PostgreSQL column name within double quotes, it becomes case-sensitive. In this case, your tool probably created the column "ID" (including the double quotes). PostgreSQL automatically interprets an unquoted column name as lowercase, so in the SELECT query above, it interprets ID as id. And the id column doesn't exist, but "ID" (with quotes) does.
Sep
11
answered What is the purpose of the keyword “ID” in PostgreSQL?
Sep
11
answered Data type for a fuzzy date?
Sep
11
answered Replacing composite key with surrogate
Sep
11
comment Replacing composite key with surrogate
What's the compelling reason to add an integer and make the existing primary key a nonclustered index instead of just making the existing primary key a nonclustered primary key?
Aug
30
revised Is there a way to recover a dropped mysql database?
Corrected spelling. ("Fegiment" is a word, but it's the wrong word here.)
Aug
30
comment How to shard 14 gb of data for archival database?
How selective is that one indexed column? How many rows do you expect each query to return?