10,382 reputation
11236
bio website
location Munich
age
visits member for 2 years, 11 months
seen 12 mins ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


Jun
11
comment Prune unused joins
I don't think this is currently possible with your setup. The "Postgres" way to do partition is using table inheritance: postgresql.org/docs/9.2/static/ddl-partitioning.html
Jun
11
comment Convert the table PROCESSLIST from InnoDB to MYISAM
Try to run your select in auto-commit mode, or end the transaction using a commit before running the select. Could be you are affected by MySQL's default isolation level REPEATABLE READ
Jun
11
comment Convert the table PROCESSLIST from InnoDB to MYISAM
And why would that require to change the storage engine?
Jun
11
comment Convert the table PROCESSLIST from InnoDB to MYISAM
Why would you want to do that in the first place? That sounds like a really weird thing to do.
Jun
11
comment PostgreSQL: Executing DDL on every schema
@RolandoMySQLDBA: Postgres instead of PostgreSQL is perfectly OK.
Jun
11
comment What are the advantages of sequences in SQL Server 2012?
@MartinSmith: true, however I think we could except some basic searching to be done before asking such a question. After all the tooltip for the downvote arrow starts with "The question does not show any research effort" which is clearly the case here.
Jun
11
comment Is there a way, in a single SQL statement to ensure that all items in a list are present in some column?
Please show us the table definition together with some sample data and expected output.
Jun
11
comment What are the advantages of sequences in SQL Server 2012?
A quick google search turns up this: stackoverflow.com/questions/10062328/sequence-vs-identity and this: sqlservergeeks.com/blogs/AhmadOsama/personal/624/… and this: sql-server-performance.com/2011/sequence-sql-server-2011 and this: sqlblog.com/blogs/john_paul_cook/archive/2013/01/01/… and this: sqlnotes.info/2011/11/18/sql-server-sequence-internal
Jun
11
comment PostgreSQL “freeze”/“unfreeze” command equivalents
@Dan: you can take a consistent snapshot using pg_dump without the need to block writes.
Jun
10
comment PostgreSQL “freeze”/“unfreeze” command equivalents
I think you are looking for pg_start_backup(): postgresql.org/docs/current/static/… But you should read this: postgresql.org/docs/current/static/backup-file.html to understand why you can't just take a filesystem backup while the server is running
Jun
10
revised Find the salary difference between two months
added 91 characters in body
Jun
10
comment Find the salary difference between two months
There is no need for the complicated self join.
Jun
10
answered Find the salary difference between two months
Jun
10
comment Does MySQL cache queries?
"in common with all other popular database products": that is a bit misleading. Hardly any DBMS actively caches query results the way MySQL does. DBMS usually only cache table (or index) data, not query results. Most of them do cache the query exeution plan (and the query "source")
Jun
10
comment Oracle: Lost significant part of foreign-keys
I don't think you can get that information because Oracle doesn't keep such a history.
Jun
10
revised Oracle: Lost significant part of foreign-keys
added 1 characters in body
Jun
10
answered Oracle Undo tablespace users
Jun
8
revised I want to change ORACLE level#2 to log archiving mode instead of the current mode
deleted 36 characters in body
Jun
7
comment Oracle remove and place (re-install) database on 10g
Do you really want to drop "the database"? Note that a "database" in Oracle is basically the whole installation, not just a single "namespace" inside the system (as e.g. in Postgres or SQL Server). It seems you just want to drop the schema (=user). In that case, drop user ... cascade is the best option.
Jun
7
comment Oracle remove and place (re-install) database on 10g
imp is not a "SQLPlus" command. It's a commandline tool.