11,424 reputation
11945
bio website
location Munich
age
visits member for 3 years, 3 months
seen 38 mins ago

Jan
2
revised MySQL - INSERT … SELECT .. FROM .. - Single transaction or transaction per row?
added 6 characters in body
Jan
1
comment Postgres - Optimizing an view dependent on an aggregate function?
You could try using distinct on or a window function to get rid of the derived table and only scan the table once then but without the execution plan and the additional information it's hard to tell.
Jan
1
comment Postgres - Optimizing an view dependent on an aggregate function?
Please read this wiki.postgresql.org/wiki/Slow_Query_Questions and add the missing information to your question (btw: the parenthesis around the actual select is totally unnecessary)
Dec
31
comment Recovery from datafiles
Doesn't support 12c though
Dec
30
comment Primary Key Question
"Repeating" the values of PK is not considered de-normalized. If the PK is really that big, that's the way it is. But (firstname, lastname, email) is not a good PK anyway (because the values of a PK should never change)
Dec
30
revised Database having only db_datareader shows invalid properties for a index
fixed spelling
Dec
30
comment Primary Key Question
Why does a "large" primary keys (and the resulting foreign keys) make the system "heavily de-normalized"? If a PK is 5 columns, then it's 5 columns. That has nothing to do with de-normalization.
Dec
30
answered Postgres 9.2 under FreeBSD 8.4 - How do I find the databases & tables?
Dec
29
comment PostgreSQL Database Data File Integrity Check
Might be worth adding that since Postgres 9.3 you can optionally enable checksums
Dec
29
comment Database consistency checker in postgresql
@MartinSmith: with the new checksum in 9.3 this shouldn't be needed?
Dec
29
revised Independent pairs of RAID 1 is superior to RAID 10
spelling, formatting
Dec
29
comment Database consistency checker in postgresql
Postgres does not need a "consistency" check. What exactly does this DBCC thing do? What exactly are you trying to achieve?
Dec
24
comment What all to start for oracle database server
@ik_zelf: not entirely true. If you want to access Oracle e.g. through JDBC you need the listener even if the JDBC app (e.g. an application server) runs on the same machine
Dec
21
reviewed Edit suggested edit on Formulating a Join Query for PostqreSQL
Dec
21
revised Formulating a Join Query for PostqreSQL
Removed thankyous and fixed the title
Dec
19
comment PostgreSQL Stored Procedure Performance
It's the first time I see the claim that PL/V8 is faster than PL/pgSQL. Do you have any (published) figures to support that?
Dec
19
revised PL/SQL Developer - empty object list
edited tags
Dec
19
revised I am not able to create this DB2 SP. What is the issue with it? Not getting it
added 65 characters in body; edited tags
Dec
18
comment Automatically schema backup in Oracle
Do you have access to the server's filesystem? In that case you can use dbms_datapump to create a schema dump.
Dec
18
revised Memory is not released after the execution stored procedure followed by a process end
edited tags