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

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


2d
reviewed Close What will be the Better database design for following table?
2d
reviewed Close Can anyone convert this SQL into Rational Algebra Format
Mar
26
reviewed Looks OK Applying Quotes Across Multiple Lines
Mar
26
reviewed Leave Open Counting daily distinct records
Mar
26
reviewed No Action Needed What will be the Better database design for following table?
Mar
26
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.
Mar
26
reviewed Reviewed Select range of non-identical date from different table
Mar
26
revised Select range of non-identical date from different table
Removed chattiness.
Mar
26
reviewed Close Use a function(select or insert) in a streaming rep with hot standby setup
Mar
26
reviewed Leave Closed migrating from Postgres to MonetDB
Mar
26
reviewed No Action Needed MySQL Workbench: How to detach reverse-engineered EER diagram from existing database?
Mar
26
revised How to handle too many inserts?
SQL is a language, not a DBMS.
Mar
26
reviewed Leave Closed MySQL query where one column is equal to another
Mar
26
reviewed Reviewed How to handle too many inserts?
Mar
26
comment How to handle too many inserts?
Which DBMS are you using?
Mar
26
reviewed No Action Needed Registered Server window does not show Database Engine or Local Server Groups
Mar
26
reviewed No Action Needed oracle database - sql for counting the columns with the same id with the one in current row
Mar
26
reviewed Looks OK Remote MySQL connection fails (10060) - “Can't connect to MySQL server on domainname.com(10060)”
Mar
26
reviewed Looks OK MySQL query where one column is equal to another
Mar
26
reviewed Close Upgrade from SQL Server database server To SQL Server Report Server