Reputation
4,724
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 17 31
Newest
 Electorate
Impact
~362k people reached

Feb
3
comment Stored procedure vs transaction anomaly
Like @a_horse_with_no_name says, this is expected behaviour!
Jan
29
comment How to combine UNION and INNER JOIN?
This doesn't answer the question.
Dec
2
comment ORA-12546: TNS:permission denied, on Windows through Task Scheduler
I'm guessing when you run normally you are running as a user that is a member of the ORADBA group, which can login into the database without supplying a password. When it runs from schedule it runs as a different user. Is this the case?
Oct
28
comment Where all can the /*+ PARALLEL */ hint be used?
This doesn't answer the question. It's just a generic statement about Oracle's parallel capabilities, not a specific answer about where the parallel hint can be used.
Oct
26
comment Error in trigger: table X is mutating, trigger/function may not see it
Your trick is really bad advice.
Oct
17
comment Execution plan depends on where output columns are concatenated
As another potential work-around, what happens if you include both the original columns and the concatenation?
Oct
8
comment Faster query with pattern-matching on multiple text fields
What's the purpose of concatenating first_name and last_name with a zero-length string between them?
Oct
8
comment Faster query with pattern-matching on multiple text fields
Which version of PostgreSQL are you using? Please edit this (and the fact that you are using B-tree indexes) into your question so we can delete these comments.
Oct
8
comment Faster query with pattern-matching on multiple text fields
I presume you are using ordinary B-tree indexes? These won't work for ilike '%something' (with leading wildcard). You'll need to add other indexes.
Oct
6
comment SQL Server - High Performance Record Comparison
But, in general, for high-performance you'll do better to switch to set-based processing rather than row-by-row, aka slow-by-slow.
Oct
6
comment SQL Server - High Performance Record Comparison
Show us your table definitions and code. Without it we're guessing.
Oct
5
comment Looking to improve query performance
No primary keys?! What about unique keys?
Oct
5
comment Looking to improve query performance
Is it possible to replace union with union all?
Oct
1
comment InnoDB: SELECT COUNT(*) using primary key 25 times slower on Windows
I presume the hardware is roughly equivalent?
Sep
30
comment Anybody know story behind pgFoundry (PostgreSQL project site) downtime?
@CraigRinger If I remember correctly, it was an email from Marc Fournier to say that it would be shutdown and a few days later an unsubscribe confirmation from a pgFoundry announce list. And now the site is gone, so I think it's fair to assume it's gone for good.
Sep
30
comment Anybody know story behind pgFoundry (PostgreSQL project site) downtime?
pgFoundry has been shutdown. I got an email about this but I can't find it anymore.
Sep
24
comment Merge two data tables with different time preferably in access
You need an outer join, not union.
Sep
21
comment Tables with FK's of each other
I wonder how many on that list are wrong? The Netherlands for example has a single capital city, but the seat of government is elsewhere. +1 for allowing this information to be represented in some way.
Sep
16
comment Design database table for property listing
Which DBMS are you using? Some DBMSes support spatial datatypes. It might be worth looking into using those.
Sep
16
comment SQL Server 2012 duplicate key error with Spatial index that shouldn't be unique
Someone didn't create the index as unique by mistake?