Reputation
Next tag badge:
93/100 score
20/20 answers
Badges
4 47 94
Newest
 Constituent
Impact
~1.8m people reached

1h
comment Should every table have a single-field surrogate/artificial primary key?
see also dba.stackexchange.com/a/112632/1396
1h
comment Entity relationship problem
If I understand correctly, this is similar reasoning to my answer on an older DBA.SE question — I plan to link to your answer from there because it's very well expressed.
Aug
24
revised Oracle Audit: Why Logons are less than 0.1% of logoffs?
added link to support 'logged on right now' claim and clarified explanation.
Aug
24
revised Oracle Audit: Why Logons are less than 0.1% of logoffs?
edited tags
Aug
21
revised How to display Postgres version in the CLI pompt?
added 267 characters in body
Aug
21
revised How to display Postgres version in the CLI pompt?
added 108 characters in body
Aug
21
answered How to display Postgres version in the CLI pompt?
Aug
20
comment Optimize PostgreSQL server setting for extremely wide tables
possibly related: stackoverflow.com/questions/2966524/…
Aug
15
revised Oracle - restore a single table
deleted 26 characters in body
Aug
12
comment query to concatenate columns if record duplicate
@AdityaShrivastava please don't move the goalposts: if you have a new question ask a new question.
Aug
12
revised query to concatenate columns if record duplicate
deleted 342 characters in body
Aug
11
comment How do I define the frequency of my mongo backup
@Carl please see my edit: I think Paul was trying to prompt you to add in extra details to further improve the answer after he added the link.
Aug
11
revised How do I define the frequency of my mongo backup
added 512 characters in body
Aug
5
comment Move database from windows server 2003 to windows 7/8?
"...they are not willing to pay for a new server licence..." then why move off 2003? Firewall it off and trust your users, or pay the license for a server OS – those are your options as I see it.
Aug
4
revised Eliminate duplicates in ListAgg (Oracle)
fixed broken links
Aug
4
revised Can I exchange partition between two table with partition with same name?
edited body
Aug
3
awarded  Constituent
Jul
28
comment Simultaneous calls to the same function: how are deadlocks occurring?
Quite right, my bad. I think I was getting confused with another thing we tried (which didn't prevent the deadlock).
Jul
28
comment Simultaneous calls to the same function: how are deadlocks occurring?
Actually it turns out you were right about lock escalation - though the mechanism is subtle.
Jul
28
awarded  Nice Question