2,869 reputation
2921
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 4 months
seen 11 hours ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


10h
comment MySQL Multi Count
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context.
14h
comment Is RMAN backup platform independent?
Well, my thinking was as follows: the first sentence is OK, but not an answer IMHO, just a comment that datapump is -- or might be possible to be run as -- platform independent, with no information as to how or why this is achieved. The second sentence adds nothing and is wrong. The third sentence is definitely a comment, but I don't know @Ahmed plans to send his classnotes.
16h
comment How can I speed up an sql query that round trips between two tables
Which query is slow? What are the execution plans for the two queries?
17h
comment How do I convert the quantities exported into millions Single Strength Equivalent gallons (millions SSE Gallons)
What does this have to do with database design or database administration?
18h
comment Is RMAN backup platform independent?
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
1d
comment Get list of characters in column
Sounds like a custom aggregate.
1d
comment Execute permission denied on object sp_start_job
This doesn't answer the question.
1d
comment Removing Secondary Replica from SQL Availability Group Causs Large Log File
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
2d
comment How to pass output of one stored procedure to the input of another
A code example of what you mean would help a lot here.
2d
comment Duplicate values
How does this answer the question?
2d
comment How to determine cost/benefit of adding an index?
I rely on pgBadger almost exclusively. And my gut.
Nov
20
comment Bulk Delete for Large Table in MySQL
And this won't affect new data being inserted/updated? I don't think so.
Nov
19
comment Setting up a centrally based server repository (database)
Great! Can you edit your question to include this information? Then delete the comment.
Nov
19
comment Setting up a centrally based server repository (database)
This is very vague. What will this database be used for? Just information, or will the "database" also need to "do things"? How do you envisage "the database" being accessed?
Nov
19
comment ORDER BY using custom priorities for text columns
Note that a) the brackets are optional: a case expression (as this is called) is valid anywhere a column can be specified; and b) the expression can be slightly simplified to case `cat` when 'mgr' then 1 when 'dev' then 2 else 3 end
Nov
18
comment count of values in a multivalue field
A where clause containing an aggregate function is almost certainly an error. Try using having instead.
Nov
18
comment After upgrade from 9.1 to 9.3, commands still point to 9.1
Why not uninstall the 9.1 versions?
Nov
14
comment Restoring master database
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.
Nov
10
comment Using triggers or php code
I'd say neither. It's a derived value.
Nov
5
comment Bulk insert into SQL Server from VMWare guest using distributed switch
Which IPS device? How does your environment compare to that of the asker and how will it solve his problem?