6,765 reputation
31438
bio website
location Berlin, Germany
age 38
visits member for 2 years, 9 months
seen 15 hours ago

Feb
1
comment Granting access to all tables for a user
Welcome to dba.se! Code-only answers are discouraged here since the 'why's are usually at least as important as 'how's. You can add explanation, links to documentation etc. in order to produce a good answer. Thanks in advance!
Feb
1
revised Granting access to all tables for a user
added 4 characters in body
Feb
1
revised Granting access to all tables for a user
retag
Feb
1
revised PostgreSQL: Can the archive command for master and standby point to the same directory?
retag
Feb
1
comment compare the same table
Could you attach the execution plan and the definition of your indexes (if any)? And the DISTINCT in the subquery is useless (I think it causes a useless sort, which is not good).
Feb
1
comment Trying to create a sequence in Oracle that starts with the max value of primary key of a specific table. Why does this not work?
'This does not work' is hardly an error code in any system. What's more, it does not describe your problem at all. Do you get an error? Or you get a sequence with the wrong values? Or?
Jan
31
reviewed No Action Needed How to query a Vertica server in C language?
Jan
31
reviewed Close Transactional Replication Over Domain
Jan
30
reviewed Close Select query from two tables which only specified rows
Jan
30
reviewed Close Expanding contractions/number ranges into separate records
Jan
30
reviewed Reviewed In DBMS binary relationship is better than ternary
Jan
30
comment In DBMS binary relationship is better than ternary
Could you give an example where you'd find a ternary relationship necessary?
Jan
30
reviewed Reviewed Which Database to choose: MySQL or Oracle
Jan
30
comment What is the correct result for this query?
May I ask where did you find the standard? If you say 'on my bookshelf' I'll be disappointed :)
Jan
30
revised optimize this query
deleted 6 characters in body; edited title
Jan
30
comment optimize this query
Firstly, between 'please' and 'pls' the difference is only 3 letters. I'll give them to you free of charge. (Read: please, post well-formed questions only if you want to be polite to others.) Otherwise there are missing information: table structure (including indexes), execution plan and time, RDBMS and so on.
Jan
30
reviewed Reviewed How to create two database copies in two users from same dump file
Jan
30
reviewed Reviewed mongodb heartbeat - unicast, broadcast or multicast?
Jan
30
revised one trigger for multiple tables
added 344 characters in body
Jan
30
answered one trigger for multiple tables