12,179 reputation
11947
bio website
location Munich
age
visits member for 3 years, 5 months
seen 20 mins ago

Mar
25
revised sqlsrvr.exe is not using all memory
edited tags
Mar
25
revised SQL Server Agent: QUOTED_IDENTIFIER
edited tags
Mar
25
revised Drop & re-add subscribers to transactional replication
edited tags
Mar
25
comment SQL Where Clause Efficiency
Check the execution plan and you'll see
Mar
24
comment Recover the postgres data if hard drive fails in CentOs 6
Restore your backup
Mar
24
comment How to know DB user?
select user from dual will tell you.
Mar
23
revised How to display '0' where no data found in PL/SQL Oracle Reports
added 30 characters in body
Mar
22
comment How do I access a result set from a StoredProcedure… in another StoredProcedure
The only thing that comes to mind is using temp tables to "transfer" the data from one procedure to the other.
Mar
22
revised Postgresql: Query across schemas
added 6 characters in body
Mar
22
comment How to do WHERE x IN (val1, val2,…) in plpgsql
WHERE col0 = ANY (intarray)
Mar
21
comment How to config Enterprisedb work with PostgresXC ?
I don't think that is possible. PostgresXC uses a different code base as the normal Postgres versions (including EnterpriseDB) so you can only create a PostgresXC cluster using PostgresXC. What exactly are you trying to do?
Mar
21
comment Which RDBMS do return better error messages?
In my opinion Postgres' error message are much clearer.
Mar
20
comment How to grant select on a view … based on IP adress?
The only thing I can think of, is to write a function that checks the client's IP address and then runs different SELECT statements based on that.
Mar
20
comment INSERT using results of CTE INSERT to provide unique id values
You need to join ins and t3
Mar
20
revised What happens when changing column type DATETIME to TIMESTAMP in MySQL?
deleted 1 characters in body
Mar
20
revised DB collation is used for comparison instead of column collation
edited tags
Mar
19
reviewed Approve suggested edit on Altering table Foreign Keys produces an error (errno:150) (MySQL)
Mar
18
comment Self-join unique pairs
Where does 1,4 or 6,8 come from? It's not the sample data (the first "table")
Mar
18
comment What is the instance name of the box I'm logged into?
What do you want to see if there is more than one instance? In most Linux distributions you can check the instances by looking at /etc/oratab
Mar
18
revised Find the second highest value from a subquery or derived table
added 12 characters in body; edited tags