SQL

Azure DocumentD8: Microsoft goes to NoSQL

Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available(…)

dbi services wishes you a Merry Christmas with this SQL Server script

The end of the year approachs and soon it will be time to celebrate Christmas with your family and friends. At dbi services, we wish you a merry christmas via SQL Server with the following script, to execute in your(…)

Oracle lateral inline view, cursor expression and 12c implicit statement result

By Franck Pachot . I’ll present here 3 ways to run a query for each result of another query. Let’s take an exemple: get all executions plan (select from dbms_xplan.display_cursor) for each of my queries (identified from v$sql). The(…)

SQL Server tips: how to list orphaned logins

I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but(…)

SQL Server tips: Executing a query with the EXECUTE command

This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string(…)

Oracle 12.1.0.2.1 Set to Join Conversion

By Franck Pachot . Recently, I described the Partial Join Evaluation transformation that appeared last year in Oracle 12c. I did it as an introduction for another transformation that appeared long time ago in 10.1.0.3 but was not(…)

Oracle 12c extended datatypes better than CLOB?

By Franck Pachot . 12c has introduced character strings that can can go above 4000 bytes. In the previous versions, in PL/SQL only we were allowed to have VARCHAR2 up to 32k. In SQL the VARCHAR2 datatype was limited(…)

ROWNUM vs ROW_NUMBER() and 12c fetch first

By Franck Pachot . Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required for result pagination. The application(…)