15,382 reputation
33774
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 4 months
seen 2 mins ago

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


Jul
14
revised Get the first and last names of all employee who entered the project at the same time as at least one other employee
added 98 characters in body
Jul
12
comment Partitioning MySQL vs PostgreSQL
I think you are barking up the wrong tree here: why do you think you need partitioning at that volume?
Jul
12
comment Partitioning MySQL vs PostgreSQL
@Alexandros I think you are misunderstand what Chris is saying - read the comments above.
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jun
27
comment How do you think in NoSQL?
@Lie that depends whether "Not only SQL" refers to procedural languages built into the database (it does not, not for the ones you mention or T-SQL or PL/SQL either) or to the language that is the API into the data storage layer itself. You can't access postgres data without SQL. Same on SQL Server, same on Oracle. I think I agree with your last sentence though - nevertheless that is what is occurring in the NoSQL world.
Jun
27
accepted Is this temp table behaviour documented?
Jun
27
revised Is this temp table behaviour documented?
added 246 characters in body
Jun
27
comment How do you think in NoSQL?
@LieRyan "All that is required for a database system to be a NoSQL is to not implement SQL" not true: NoSQL stands for "Not Only SQL".
Jun
27
comment How do you think in NoSQL?
@Vérace no, it is not a good fit for dba.se, it's far far too broad. We welcome specific answerable questions that don't solicit opinion and for which you couldn't imagine a whole book being written in answer. Usually that means specifying the exact platform (eg "MongoDB", not "NoSQL") as a minimum starting point. Note that I'm not saying the question isn't interesting just that it is not a good fit. If you want to answer this the right place would be on our blog not on main.
Jun
24
comment Move Oracle database to new server
By "without violating Oracle SE license" do you mean "only having one database mounted at a time"?
Jun
24
comment How to improve query performance in PostgreSQL?
@Craig please feel free to flag posts like this that are going nowhere and I'll close them. Read your blog post about CTEs and materialization the other day, thanks for that.
Jun
24
comment How to improve query performance in PostgreSQL?
This isn't working out here: as Craig has said, you need to go back to the drawing board and figure out what you are trying to achieve. I note that you still have rows=215655059 in your plan so perhaps you just have an unrealistic target.
Jun
17
awarded  Generalist
Jun
12
awarded  Popular Question
Jun
9
comment SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrect
@mr5 tools like SSMS are on topic here. Can you post your comment as an answer?
Jun
7
revised Recovery from datafiles
edited tags; edited tags
Jun
6
comment Why can't I drop this Oracle datafile - even though it seems empty?
He should be able to drop just the datafile if it is empty. This looks a lot like bug 12735162 to me.
May
31
answered What is the difference between Interbase and Firebird?
May
31
comment How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
Thanks Erwin, it is now! Checking the link, it looks like it addresses the locking issues but like vacuum full/cluster does a full table re-write which my application can't afford, both for space reasons and because of the WAL generated.