Database Administration & Monitoring, Development & Performance SQL Server 2016 query store 19.10.2015 by Microsoft Team 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(…)
Development & Performance Want to benchmark your storage? It’s time to switch to DiskSpd tool! 08.10.2015 by Microsoft Team 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(…)
Development & Performance Join transitive closure and query simplification considerations 10.09.2015 by Microsoft Team 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(…)
Development & Performance, Oracle DataBase Cloud Service performance – IOPS 28.08.2015 by Oracle Team 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.
Development & Performance sp_cursor_fetch and performance considerations 27.08.2015 by Microsoft Team 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(…)
Development & Performance, Oracle OCM 12c preparation: Materialized View explain_rewrite 23.08.2015 by Oracle Team 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(…)
Development & Performance SAP HANA SQL scripting optimization: the CE Functions 12.06.2015 by Alain Lacour 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(…)
Development & Performance Row Store vs Column Store in SAP HANA 21.05.2015 by Alain Lacour 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(…)
Development & Performance Variations on 1M rows insert (3): using SQL Server In-Memory features 19.05.2015 by Microsoft Team 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(…)