3,245 reputation
21323
bio website datajini.com
location Frösön, Sweden
age 42
visits member for 2 years, 8 months
seen 16 mins ago

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


14h
comment mysql - order by first condition in where clause
order by name like 'ci%' desc, name will also work but isn't very intuitive. order by not name like 'ci%', name is one character shorter even -- and is completely counterintuitive.
14h
comment mysql - order by first condition in where clause
Thanks... I can never remember if '%' means "zero or more" or "one or more".
14h
comment mysql - order by first condition in where clause
Thanks @ypercube! I edited that in the original question where it was wrong, and promptly did it myself too!
16h
comment Can I setup database triggers to run on a defined secondary set of servers only?
What are you logging? Inserts/updates/deletes on certain tables? How many users do you have? What volume of transactions? We do it for our back-office systems to keep track of changes on key tables; these triggers cause us very little extra overhead. And it's functionally exactly what we need.
16h
comment Can I setup database triggers to run on a defined secondary set of servers only?
Triggers happen synchronously in the original user's transaction. What you are proposing would decouple that. The results wouldn't be seen immediately but a short time after. Is that what you want?
20h
comment Oracle 12c create user
Setting a hidden parameter is the answer to this problem? If indeed it is, please explain why this helps and why this is the correct solution. As it is the answer is too terse.
1d
comment Is there a way to improve this query further?
Your query, not so much. The table: if day and data are both always filled, you should make them not null. You'll probably want to use the new jsonb datatype instead of json too.
1d
comment How to handle too many inserts?
Which DBMS are you using?
2d
comment SQL Server not starting at Windows startup but starts manually
It's more common to assume an OS commonly used with the software in question; a version of Windows Server would be a good assumption; a pre-release version of a desktop OS isn't.
2d
comment Clean SQL Server database
possible duplicate of Shrink my .mdf file in SQL Server?
2d
comment trying to a lag a column in SQLite
See stackoverflow.com/questions/10003313/… But like I said, I'd move to a different DBMS. One that supports LAG() would be a good choice...
2d
comment trying to a lag a column in SQLite
@tblPhil Just temporarily? I'd definitely move to a different DBMS with those kinds of volumes. Nothing "lite" about it :-)
2d
comment How to Solve ERROR 1064 (42000)?
To fix syntax errors? Really?
2d
comment how to display parent items with thier child items in mysql data base
How does this display data in the structure the asker wants?
Mar
24
comment PostgreSQL trigger copy record to another table with different columns order
Listing the column names is probably the only way you're going to get this to work. I'd query metadata to generate column lists or even entire triggers.
Mar
24
comment High Availability using SQL Server 2012 requires how many licenses
I'm voting to close this question as off-topic because licensing questions are off-topic here.
Mar
24
comment PostgreSQL trigger copy record to another table with different columns order
Erm, why not just list the column names?
Mar
24
comment What is the impact on a running database when OS date is changed and set to past
Why not try it in a development or test environment?
Mar
24
comment levelDB integration in an exe
I'm voting to close this question as off-topic because this isn't a job board!
Mar
23
comment Processors: E5-4620 v2 vs E5-2620 v3
I'd probably go for the R730 as it's a newer generation machine. In theory this means it's faster, more efficient and you'll be able to get support for it longer. In theory.