Development & Performance

SQL Server 2016 query store

One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans(…)

Want to benchmark your storage? It’s time to switch to DiskSpd tool!

As you certainly know, the well-known tool SQLIO is officially deprecated since few months. From my part, I had the opportunity (maybe the last) to use SQLIO for a customer project in order to benchmark the storage for SQL Server(…)

Join transitive closure and query simplification considerations

Yesterday, I had a discussion with one of my friend who works with Oracle about some different behaviours between each query optimizer against one particular query. You can read his blog post and get the repro script here. I(…)

DataBase Cloud Service performance – IOPS

By Franck Pachot . Having a database in the cloud is very nice. You add storage with a few clicks. You don’t have to think about the storage type (DAS, SAN, NAS), size of disks, stripe size, SSD, etc.

sp_cursor_fetch and performance considerations

A couple of weeks ago, I performed a SQL Server audit and my customer talked me about a performance issue he faced only during the login phase of its application. After various exchange of information between my customer and the(…)

OCM 12c preparation: Materialized View explain_rewrite

By Franck Pachot . When I passed the OCM 11g exam, I had to prepare the 'Manage Materialized Views to improve rewrite' topic. Now that I'm preparing the 12c upgrade I checked quickly what I've(…)

SAP HANA SQL scripting optimization: the CE Functions

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(…)

SQL Server 2016 CTP2 : first thoughts about tempdb database

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(…)

Row Store vs Column Store in SAP HANA

The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two(…)

Variations on 1M rows insert (3): using SQL Server In-Memory features

Let’s continue with this series about inserting 1M rows and let’s perform the same test with a new variation by using SQL Server In-Memory features. For this blog post, I will still use a minimal configuration that consists of only(…)