Reputation
3,478
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 13 23
Newest
 Marshal
Impact
~182k people reached

2d
reviewed Leave Closed Riak vs DynamoDB, on AWS infrastructure
2d
reviewed No Action Needed Mysql: How does circular replication avoid infinite looping of a transaction
2d
comment Oracle Conditional sum
Hopefully Oracle one day supports the filter syntax: select count(*) filter (where x > 0) as positive, count(*) filter (where x < 0) as negative from t; This works in PostgreSQL 9.4+, if anyone is interested.
2d
reviewed Close phpmyadmin csv ms excel export with results different than phpmyadmin
2d
reviewed Close Postgresql Query equivalent to VLookUp of Excel
2d
reviewed No Action Needed MySQL Data directory move (WAMP)
2d
comment Unable to create read only user— postgresql 9.4
Did you commit;?
2d
reviewed No Action Needed Oracle Conditional sum
2d
reviewed Looks OK Mathematical equality of two SQL statements
2d
reviewed No Action Needed Generate create script for all indexes
2d
reviewed No Action Needed Postgresql Query equivalent to VLookUp of Excel
2d
reviewed Approve Best way to store, query and update 300M rows of data
2d
comment Inaccurate count when using multiple count functions in PostgreSQL
If you have PostgreSQL 9.4 (or higher), then you should look into the filter clause on your aggregate expressions.
2d
comment PostgreSQL: raise error if planner needs to do an sequence scan
And don't forget that a sequential scan of the table can be faster than an index scan and associated table lookup. I'm missing the "why" aspect to your question.
2d
comment merge multiple fields of csv file while running mysqlimport command
Running on a unix-like system? Why not use some commands like cut or awk first?
2d
reviewed No Action Needed SQL Server Mirroring can't connect to mirror database
2d
reviewed No Action Needed merge multiple fields of csv file while running mysqlimport command
2d
reviewed Approve How to convert mysql database charset to utf-8
2d
comment PostgreSQL: raise error if planner needs to do an sequence scan
In addition, you can't stop PostgreSQL from using sequential scans, see postgresql.org/docs/9.4/static/…
2d
comment PostgreSQL: raise error if planner needs to do an sequence scan
You could run explain on your statements first and check the output.