BE SHARING

All articles

SQL Server 2016: availability groups and the new option DB_FAILOVER

12.06.2015 by Microsoft Team

Let’s continue the SQL Server 2016’s discovery with one of my favourite topic: the AlwaysOn availability groups (AAGs). There are some improvements on this area. First of all, let’s introduce one of them (DB_FAILOVER option) by remembering of the availability(…)

Database management

Oracle memory advisors: how relevant ?

12.06.2015 by Oracle Team

By Franck Pachot . Do you look at memory advisors? I usually don’t but I still show them during the performance tuning workshop because there is no easy way to get an idea about memory sizing. This morning, while(…)

Database management

How to disable a SQL Plan Directive permanently

12.06.2015 by Oracle Team

By Franck Pachot . In 12c you will see a lot of SQL Plan Directives. Some are useful to get better execution plans, but some will trigger too much Adaptive Dynamic Sampling and that can become a big overhead,(…)

Development & Performance

SAP HANA SQL scripting optimization: the CE Functions

12.06.2015 by Matthieu Munch

In SAP HANA, you have two possibilities to create the Calculated Views: Using the graphical method Using the scripting method with CE functions In this blog, I will demonstrate that CE Functions can improve performances from a Calculated(…)

Development & Performance

SQL Server 2016 CTP2 : first thoughts about tempdb database

12.06.2015 by Microsoft Team

In my first blog about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement(…)

Database management

Convert a snapshot standby to a new database

12.06.2015 by Oracle Team

By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back(…)

Technology Survey

SQL Server 2016 CTP2 is out!

12.06.2015 by Microsoft Team

As announced by Satya Nadella at the Microsoft Ignite keynote in Chicago, SQL Server 2016 CTP2 is finally out and it follows a previous private CTP. This CTP will provide some(…)

Database management

12c Dynamic Sampling and Standard Edition

12.06.2015 by Oracle Team

By Franck Pachot . 12c is coming with more dynamic sampling, now called dynamic statistics and using the new Adaptive Dynamic Sampling algorithm. The goal is to have better estimations and better estimations gives better execution plans. However, this(…)

Database management

How to import SQL Plan Directives

12.06.2015 by Oracle Team

By Franck Pachot . Today I’ve presented SQL Plan Directives at the SOUG Romandie event. I had a question about the import/export of directives by Data Pump. The idea is that a lot of testing has been done on(…)

Database management

DBA_SQL_PLAN_DIRECTIVE.LAST_USED

12.06.2015 by Oracle Team

By Franck Pachot . If you have read Matching SQL Plan Directives and queries using it then you know how to use the ‘+metrics’ format of dbms_xplan. 21:49:54 SQL> explain plan for select distinct * from DEMO_TABLE where a=0(…)