All articles

Adaptive Plan: How much can STATISTICS COLLECTOR buffer?

By Franck Pachot . The 12c adaptive plan prepares two join methods (Hash Join and Nested Loop), actives the one that has the better cost for the estimated cardinality and computes the point of inflection in cardinality estimation where the(…)

Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy

After the good article “A short glance at Attunity replicate” from Franck Pachot, I will continue to explain our test on Attunity Replicate with datatype and how this(…)

xPlore list all ids from xhive

I went into a case that I found a kid of ‘Ghost’ index which I may present in another blog. But to summarize I had to get the full list of indexes from the xPlore server. The problem is(…)

SQL Server 2016: Microsoft R Server

In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.

When a query has read 350TB after 73K nested loops

By Franck Pachot . According that you have Tuning Pack, SQL Monitor is the right way to see what a query is currently doing. A query was running for days and the first figure I see is that it has(…)

SQL Server: switch partition and metadata inconsistency issue

In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL(…)

Testing Oracle on exoscale.ch

By Franck Pachot . My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland(…)

Can you become a PaaS provider for an Oracle Database service?

By Franck Pachot . This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has(…)

The (almost) same sample schema for all major relational databases (4) – MSSQL

In previous posts, my colleague Daniel Westermann explained how to install the “Dell DVD Store Database Test Suite” into PostgreSQL, Oracle and MySQL. This time, this is my job to present you how to proceed(…)

Connecting your PostgreSQL instance to a MariaDB/MySQL instance

Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I'll do the same with a MariaDB/MySQL instance.