Development & Performance

SQL Server 2016: IF EXISTS is included in the DROP command

With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)

SQL Server Collation for System Center Products

A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in(…)

SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I(…)

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