2,160 reputation
318
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 1 year, 9 months
seen 19 hours ago

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


Apr
17
reviewed No Action Needed Latitude and Longtitude Distance Calculation
Apr
17
reviewed No Action Needed Amazon rds MySql -> concurrent connections deadlocks
Apr
17
reviewed No Action Needed MySQL database stops working after log enabled
Apr
17
reviewed No Action Needed How to design a database structure for different groups of contacts?
Apr
17
comment ERWIN create and use database
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.
Apr
16
reviewed No Action Needed How do I use a temporary table to generate a template of results and then fill it?
Apr
16
comment Oracle: Truncate large table takes forever
Or if you have a license for partitioning: create a partitioned table containing just the single partition. Then use partition exchange with an empty table. Then drop or truncate the exchanged table at your leisure.
Apr
16
comment Oracle: Truncate large table takes forever
Sorry, but if you're going to go the trouble of dropping the table you might as well do it cleanly: rename the original table to "delete_me" and create a new table in its place. Then drop "delete_me" at your leisure.
Apr
16
reviewed Looks Good SQL Agent still attempting replication for deleted publication
Apr
16
comment SQL Server query disk write/sec limit
Change your code from "row by row" to set-based processing and you'll notice orders of magnitude improvement.
Apr
16
reviewed Reviewed How to upload a PDF to Access database?
Apr
16
comment How to upload a PDF to Access database?
What exactly is your problem here?
Apr
16
reviewed Approve suggested edit on Which is faster in process time?
Apr
16
comment SQL Server query disk write/sec limit
I'm guessing each session is CPU bound, and you have multiple cores.
Apr
16
comment SQL Server query disk write/sec limit
You are inserting "row by row" aka "slow by slow". You'll get a lot more throughput if you turn this into a set operation, see sqlperformance.com/2013/01/t-sql-queries/generate-a-set-1 for some ideas on how to do that.
Apr
16
reviewed No Action Needed SQL Server query disk write/sec limit
Apr
16
reviewed No Action Needed How to stop the execution of a long running insert query?
Apr
16
comment PostgreSQL DB size increasing after restoring the same database backup
An absence of primary or unique keys would do that... but then you don't have data, you have junk.
Apr
16
reviewed Approve suggested edit on How to upload a PDF to Access database?
Apr
15
reviewed No Action Needed Fan-In replication 4 Master -> 1 slave