2,811 reputation
1920
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 1 month
seen 5 hours ago

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


11h
comment Speed up a MySQL BETWEEN query
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.
15h
comment InnoDB deadlock with INSERT .. SELECT
Can you post your exact statements?
18h
comment Speed up sorting in this query
Can you add the query and execution plan in the body of the question? We don't like to rely on external links here. And also add the relevant table definitions including indexes.
18h
comment I cant figure out the error probably with the date field in this mysql stored procedure
In many procedural languages, the sizes of datatypes aren't applicable. Check the syntax for those.
18h
comment creat an Avilabilit Group SQL Server 2014
You will probably get more attention to your question if you make the effort to use correct grammar and spelling.
18h
comment Launching an RDS in a private subnet in VPC and access it from a web application
I'd delete this question here and ask it over on ServerFault. It seems to be purely a system administration question and nothing specifically for a DBA.
18h
comment What is the best approach to process huge amount of data insertion efficiently
Please quantify HUGE.
1d
comment what is inventory cleansing and data cleaning?
Sounds like an exam or homework question.
1d
comment Oracle monitor tool
NB Both the Diagnostics Pack and Tuning Pack require licenses to use them. If your team doesn't have a DBA, it's highly likely your organisation doesn't have licenses for these packs either.
1d
comment Oracle monitor tool
Please explain how you get to that conclusion from the information provided. I'm not saying you're wrong, but as it is this is basically a comment, not an answer.
1d
comment Avoiding Functions() in the Where clause
I was going to suggest a virtual column (Oracle terminology for computed column) next!
1d
comment Avoiding Functions() in the Where clause
Function-based index?
1d
comment How to design database with january-december for every entry
Or you could write a view which "spreads" the item_quantity over 12 months.
2d
comment Taking a backup of a single table in the SQL Server
Somehow I don't think it's this easy.
2d
comment No query cache efficiency mairaDB
How many queries have you run? 87 isn't many, unless they were all on the same table.
2d
comment hierarchical retreival of records in postgresql
Why not? I don't understand your argument.
2d
comment Stored Procedure's Commented line causing issues
We're going to need to see your code to be able to answer this one.
2d
comment Oracle monitor tool
What do you mean by "out of memory" problem? Are you getting (a) certain error(s), and if so, which one(s)? Which OS? Do you have access to the server at OS level, or just via Oracle sessions? You'll need to add more information -- as it stands this question runs the risk of being closed as "Unclear what you are asking".
2d
comment Selecting rows with condition on two columns together
And what about the other "zillion" conditions?
Aug
23
comment Stack Depth Limit Exceeded (After delete trigger)
There's no need to delete the parent if the delete of the child is caused by the cascade delete of the parent... Can you use some variable to indicate that this is the case and don't delete the parent in this case?