11,153 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 31 mins ago

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
comment Find the salary difference between two months
There is no need for the complicated self join.
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
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.
Jun
6
comment pg_dump 9.2.x command does not work with pg_dump 9.2.3
Maybe there is an old pg_dump on the path. What does pg_dump --version show?
Jun
5
comment Should date formats be specified in SQL statements?
Localization settings of the DBMS (or the connection) have nothing to do with localizing the application. The Oracle JDBC driver for example initializes the NLS "environment" based on the language of your operating system and your regional settings. So one query might run on my computer but not on your computer regardless of the application that is using the database.
Jun
5
comment How to import a text file with '|' delimited data to PostgreSQL database?
Your header (and data) contains an "empty" column at the end, because it ends with two commas: ..EXPEDITEDREVIEW,,
Jun
4
comment What happens when I try to store more 8019 bytes in a SQL Server table row?
@MartinSmith: thanks. I wasn't aware of that. Will a small value (eg. 100 chars) for a varchar(max) column be stored "inline" or "out-of-row"
Jun
4
comment What happens when I try to store more 8019 bytes in a SQL Server table row?
@MartinSmith: does that mean varchar(7000) will be stored off-row as well? I thought that only happens with varchar(max) (hence my comment)
Jun
1
comment Exporting database Oracle 7.3 on Windows NT 3.51
I'm sure even Windows NT could take proper screenshots...