16,086 reputation
33982
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 8 months
seen 3 hours ago

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


Dec
10
revised How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
added 131 characters in body
Dec
10
comment Open tran for Select query
@JohnM that's over on SO - if this is a legit question (I can't tell), then it'd be good to have it answered here. Are you able to edit the question into shape as you seem to understand it?
Dec
10
comment What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
@Pacerier that would be better, I agree :)
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
I read about that on your blog earlier today while researching this question :)
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
actually, I guess it's fairly obvious, and unlikely to ever change, as inlining would require wrapping in a case expression, wouldn't it?
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
Really useful to know that strict prevents inlining, is this in the docs somewhere?
Dec
9
accepted Is it safe to use set-returning sql functions instead of security-barrier views?
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
Thanks Craig - fv() isn't strict here and is language SQL, so presumably there is some other reason why it isn't being inlined in this particular case, right?
Dec
9
asked Is it safe to use set-returning sql functions instead of security-barrier views?
Dec
9
revised Postgresql service run failure
edited tags
Dec
6
asked How do you truncate a `date` (not `timestamptz`) to month?
Dec
6
answered How do you truncate a `date` (not `timestamptz`) to month?
Dec
6
revised How to reduce mysql memory used
edited in useful info from blog post
Dec
6
awarded  Popular Question
Dec
6
revised SQL to select all siblings with specific child
fixed formatting/grammar
Dec
1
revised Linux kernel parameters for oracle
deleted 64 characters in body
Nov
30
comment multi-master to single-slave replication at table level with PostgreSQL or MySQL
Very clean, and getting easier to use with foreign data wrappers making cross-database querying easier.
Nov
30
revised Can I use Oracle Standard or Enterprise edition for my own training purposes?
deleted 16 characters in body
Nov
30
answered Can I use Oracle Standard or Enterprise edition for my own training purposes?
Nov
20
comment Bulk Delete for Large Table in MySQL
@TianyiCong you have a new question: please ask it as a new question and perhaps comment here with a link, don't ask it in comments that's not how this site works.