Reputation
6,370
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
13 31
Newest
 Good Answer
Impact
~468k people reached

Nov
2
comment PostgreSQL 9.1 - Asynchroneous commits performance boost
Thanks, Craig. I incorporated that into the answer.
Nov
2
revised PostgreSQL 9.1 - Asynchroneous commits performance boost
Addes SET synchronous_commit = on
Nov
1
answered PostgreSQL 9.1 - Asynchroneous commits performance boost
Oct
31
comment Broken SELECT in Sql Server Compact 3.5 SP2?
You could isolate index issues by dropping the index.
Oct
31
comment Is the optimisation fence behaviour of a CTE (WITH query) specified in the SQL:2008 standard? If so, where?
I think writable CTEs are not yet in any SQL standards, but I'm not positive.
Oct
31
answered Is the optimisation fence behaviour of a CTE (WITH query) specified in the SQL:2008 standard? If so, where?
Oct
26
comment query discrepancies on very large postgres table
What version of PostgreSQL?
Oct
20
comment Why does DELETE leave a lingering effect on performance?
I'm going to stop answering questions today. Or whatever it is I'm doing when I type things into that box.
Oct
20
answered Why does DELETE leave a lingering effect on performance?
Oct
18
comment How do I create a user-defined aggregate function?
I don't know. It was documented as "C or C++ (or another language that can use C calling conventions)" in version 5.0. The docs dropped "or another language that can use C calling conventions" in version 5.1. That's a strange phrase to drop.
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