11,143 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 2 hours ago

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...
May
31
comment Different dates Oracle 11g with TOAD
Why convert a string to a date, then to a string and back to a date again? What are you trying to achieve?
May
30
comment pgAdmin3 can't connect properly to Postgres 9.2
What kind of operating system is that, that doesn't let you install new versions? Can't you just download the binaries from pgadmin.org and install them?
May
30
comment Are there major drawbacks/risk of using oracle blob to store files
The disk space won't be that different between a BLOB in Oracle and the same data stored as a file.
May
26
comment exported .SQL file won't import completely in mySQL
How do you think we can help you if you don't show us the SQL that causes the error?
May
24
comment How to design indexes for columns with NULL values in MySQL?
@user4035: ah, thanks. Then it's probably the NOT that prohibits the use of an index.
May
24
comment How to design indexes for columns with NULL values in MySQL?
If I'm not mistaken, MySQL cannot use an index for any NULL comparison (but a condition selecting 50% of the rows wouldn't probably use an index anyway even if the condition could make use of an index)
May
23
comment BLOBs storage in a dedicated table
Why would splitting up a table into two tables make "application code writing" any easier. Now you need to first get the PK from the base table and get the blob from the second. Or always join the blob table to the base table. Seems an awful big overhead for a non-existing problem.
May
23
comment Tools and methodologies to keep to DBs aligned
We are quite satisfied using Liquibase for this.
May
22
comment How to store many smallish time-series in a relational DB?
I think this could be stored quite efficiently in Postgres using the hstore datatype ("NoSQL" like key/value type) or an array but that is obviously not an option. I think having one table for the values is probably going to be the most maintainable solution. You probably want to partition that table by measurement_id
May
20
comment Inner join using an array column
The equality operator in SQL is = not ==
May
20
comment Inner join using an array column
The equality operator in SQL is = not ==
May
19
comment Make rows immutable allow Insert mysql5
Cross posted: stackoverflow.com/questions/16634741
May
18
comment How to make continues cluster?
How can the table have 30 million rows in total yet have 20 million per month? Are only storing one and a half months in there?