2,906 reputation
21021
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 5 months
seen 7 hours ago

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


18h
comment Automating SQL Server Merge Replication Processes
Which DBMS are we talking about?
1d
comment what is the difference between data migration and ETL?
I see the distinction as data migration being a once-off process done to move data from one system to another, while ETL is a process used to move data between systems on a regular basis.
2d
comment Best approach to get last value inserted
Number 3 works well for me. Make sure you have an index on (device_id, date_inserted desc).
Dec
16
comment ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file
What are you doing to get this error?
Dec
16
comment postgres service suddenly not working after the computer crashed while working
I strongly doubt this would solve the problem the asker was having.
Dec
10
comment Counting repeated occurences for a group of fields
No, it's a tag. I've tagged this question, but maybe other questions and answers will help you. You'll almost certainly need to use window functions to identify the start and/or end of the sequences you're interested in (partitioning by person and ordering by time). I started to write a query but I would need sample data: can you edit your question to include this as a script, or a link to a SQL Fiddle containing said data?
Dec
10
comment Counting repeated occurences for a group of fields
@Ypercube Probably.
Dec
10
comment Counting repeated occurences for a group of fields
Or should Dave be 6?
Dec
10
comment ORA-01779: cannot modify a column which maps to a non key-preserved table
possible duplicate of Oracle: Non key-preserved table should be
Dec
10
comment How to empty a column in mysql
"empty"? Please show us the SQL you (would) use(d).
Dec
8
comment Create relationship between two tables with composite primary key
Also -- though it doesn't solve your problem -- the second statement contains an error: the column phone doesn't exist.
Dec
4
comment i have make a database program in visual basic 2010.how i can set the 2 programs to see each other on 2 pc?
Which DBMS are you using? SQL Server?
Nov
30
comment Manager a multivalued attribute?
It all depends on your requirements. And that's just one alternative way to model it.
Nov
27
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.
Nov
27
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?
Nov
27
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.
Nov
26
comment Get list of characters in column
Sounds like a custom aggregate.
Nov
26
comment Execute permission denied on object sp_start_job
This doesn't answer the question.
Nov
25
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.
Nov
25
comment How to determine cost/benefit of adding an index?
I rely on pgBadger almost exclusively. And my gut.