Reputation
14,152
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 25 54
Newest
 Enlightened
Impact
~797k people reached

Mar
23
comment What's the fastest way to migrate an Oracle database from Unix to Linux?
If Oracle is already running on the RedHat server, use expdp and impdp (or just impdp through a DBlink)
Mar
23
comment Oracle can't drop index with . in name?
docs.oracle.com/cd/E11882_01/server.112/e41084/…
Mar
23
comment Postgres 9.1 - Select Query is in waiting status
If the status is waiting then it's blocked by some other process. Maybe an un-committed DDL statement (such as alter table)
Mar
21
comment Trouble renaming a PostgreSQL database
This is explained here and here
Mar
21
comment Stop PostgreSQL from logging statements on error
log_min_messages and log_min_error_statement: postgresql.org/docs/current/static/…
Mar
21
comment Does Postgres preserve insertion order of records?
I think Sergey was more referring to the question whether the first row will always get id = 1, the second id = 2 and the third id = 3 - not the actual "order" or the rows
Mar
20
comment Postgresql: Update or insert stuck
Show us the execution plan. wiki.postgresql.org/wiki/Slow_Query_Questions
Mar
20
comment Postgres: difference between CTE and temporary table
Not identical because a CTE is not necessarily written to disk
Mar
20
comment Postgres equivalent of SQL Server recovery model Simple
There is no equivalent because Postgres does not have a transaction log the way SQL Server does. If at all then an installation that does not do WAL archiving (which is the default) could be seen as somewhat equivalent
Mar
20
comment How to identify concurrency issues in Oracle 11g?
cursor: mutex S is very often the sign of excessive hard (or even) parsing. Is your application using prepared statements ("bind variables")? And why are you using dictionary managed tablespaces? Oracle highly recommends to use locally managed tablespaces.
Mar
20
comment Alias using “AS” and without using “AS”
There is no difference.
Mar
20
comment What is the query to get the process limit on Oracle 11g?
docs.oracle.com/cd/E11882_01/server.112/e40402/…
Mar
20
comment What is the query to get the process limit on Oracle 11g?
show parameter processes
Mar
20
comment Postgres 9.1 - Select Query is in waiting status
What do you mean with "waiting"? What is the status of that connection as shown by pg_stat_activity? What is the status of the other connections? What does the statement do? What is the execution plan of the statement? What are the table definitions of the tables involved?
Mar
19
comment ORA-12154 TNS:could not resolve service name from PL/SQL, but SQL Developer Connects Fine
SQL Developer being a Java application uses the JDBC driver which neither needs an Oracle client nor tnsnames.ora.
Mar
19
comment Thousands of the same weird syntax error after 9.4 upgrade
Those statements are sent from pgBouncer, maybe you need to upgrade that as well.
Mar
19
comment Replace nested “select with count” with outer join? is this possible?
@DavoinShowerhandles: yes it will
Mar
19
comment Replace nested “select with count” with outer join? is this possible?
Which DBMS are you using? Postgres? Oracle?
Mar
18
comment Count data using multiple date ranges
You need so sum clicks not 1
Mar
18
comment How to return updated data from UPDATE … FROM query?
returning tbl1.*?