15,378 reputation
33774
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 3 months
seen 4 hours 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.


4h
comment Formal name for functions that use the OVER clause
@a_horse yes, they chose that term in SQL2003 over the Oracle term that pre-dates it. Fwiw I think it was the right choice, it's far more descriptive.
4h
comment Formal name for functions that use the OVER clause
They were called 'analytic' functions on Oracle for many years, but 'window(ing) functions' is the more generic term.
4h
revised Formal name for functions that use the OVER clause
edited tags
2d
comment Database Design for classifieds site
I think the minimum you need to do to make this less broad is provide a SQLFiddle.
2d
comment Why are some aggregates treated differently in the RHS of a rule in the model clause?
I forgot about this and hit it again today. At least it reminded me to accept your answer, thanks :)
2d
accepted Why are some aggregates treated differently in the RHS of a rule in the model clause?
Jul
26
revised How do I select 1st row of each table and insert that data to a new table
added 177 characters in body
Jul
23
revised Conditionally sum a column based on a mod result
added 1 character in body
Jul
23
comment ORA-00922 encountered in Oracle 11gR2 installer
Can you edit that info into the answer? It's better there than in the comments and it looks like useful info.
Jul
23
comment Repair Corrupt Access Database File
You aren't affiliated with MDB Repair Kit in any way are you?
Jul
23
revised Long running simple query SQL Server 2008 R2
deleted 106 characters in body
Jul
21
comment Plural vs Singular Table Name
Another point along the same lines.
Jul
19
revised Difference between database dump (export) and database backup?
added 11 characters in body; edited tags
Jul
19
reviewed Reject suggested edit on SQL Server Management Studio does not load
Jul
16
comment As a DBA, how would I go about transitioning from Oracle to SQL Server?
Is it worth adding a bit about lock escalation here? I think it'd come as a surprise to may Oracle folk used to unlimited row level locks
Jul
16
comment MySQL is running but not working
@RolandoMySQLDBA I've closed this as "Too Localized" per this comment: dba.stackexchange.com/questions/42096/… - out of interest did you VtC?
Jul
16
comment Update Only Rows With Shared/Similar Value
Please don't cross-post identical questions.
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.