Reputation
6,130
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
11 30
Newest
 Enlightened
Impact
~423k people reached

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
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?