16,077 reputation
33882
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 8 months
seen 11 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.


17h
revised Simple DELETE, but complicated execution plan
deleted 97 characters in body
2d
revised Why do we use Group by 1 and Group by 1,2,3 in SQL query?
not supported in Oracle either - removing teradata just in case
Dec
17
revised After mysql server restarts I cannot see my own database
appended answer 86368 as supplemental
Dec
15
comment DB2 9.5 - Shrink Tablespace
The command alter tablespace TABLESPACE1 reduce looks fine - can you show a screenshot with the command and the error message displayed?
Dec
15
comment Query execution time in Oracle SQL Developer
@JonofAllTrades I'm using 4.0.0.3 and mine still resets. I'm unlikely to upgrade because for every issue that gets fixed I get bitten by a new one.
Dec
15
comment ORA-00937: not a single-group group function
both COUNT and WM_CONCAT are aggregate functions so you are selecting nested aggregates - Oracle is unusual in that this is permitted, but it isn't clear what you are actually truing to achieve. Please add some sample data and the result you want - a SQLFiddle would be even better.
Dec
13
comment Setup error :Attempted to perform an unauthorized operation
@Shanky my reason is this: "you are actually installing SQL Server 2008 R2 but in your question you have clearly in Bold written SQL Server 2012" - that makes it too localized I think, but lets discuss in The Heap
Dec
12
comment How to choose a collation for international database?
Do you use the C locale (or 'non locale' to be precise) by default for any new database?
Dec
11
reviewed Approve Trimming the first and last characters from a field
Dec
11
asked Can I use `on delete set null` on a compound foreign key which contains a primary key column?
Dec
11
answered Can I use `on delete set null` on a compound foreign key which contains a primary key column?
Dec
10
accepted How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
Dec
10
revised How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?
added 131 characters in body
Dec
10
comment Open tran for Select query
@JohnM that's over on SO - if this is a legit question (I can't tell), then it'd be good to have it answered here. Are you able to edit the question into shape as you seem to understand it?
Dec
10
comment What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
@Pacerier that would be better, I agree :)
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
I read about that on your blog earlier today while researching this question :)
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
actually, I guess it's fairly obvious, and unlikely to ever change, as inlining would require wrapping in a case expression, wouldn't it?
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
Really useful to know that strict prevents inlining, is this in the docs somewhere?
Dec
9
accepted Is it safe to use set-returning sql functions instead of security-barrier views?
Dec
9
comment Is it safe to use set-returning sql functions instead of security-barrier views?
Thanks Craig - fv() isn't strict here and is language SQL, so presumably there is some other reason why it isn't being inlined in this particular case, right?