BE SHARING

Steven Naudet

SQL Server: Heap page deallocation and IndexOptimize

23.01.2023 by Steven Naudet

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.

Database Administration & Monitoring

SQL Server Deadlock on UPDATE with Serializable isolation level

10.08.2022 by Steven Naudet

Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented(…)

Database Administration & Monitoring

First look at SQL Server 2022 Contained Availability Groups

09.06.2022 by Steven Naudet

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)

Database Administration & Monitoring

SQL Server 2022 Parameter Sensitive Plan optimization

01.06.2022 by Steven Naudet

Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some(…)

Database Administration & Monitoring

SQL Server 2022 public preview available

31.05.2022 by Steven Naudet

This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022(…)

Database Administration & Monitoring

SQL Server: Find who forced a plan in Query Store with this new XEvent

22.04.2022 by Steven Naudet

The latest Cumulative Update for SQL Server 2019 has been released this week on Monday. It brings many bug fixes and some small improvements. One of these improvements is the addition of an extended event to identify the(…)

Database Administration & Monitoring

SQL Server: Automatic Soft-NUMA and uneven CPU load

20.04.2022 by Steven Naudet

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not(…)

SQL Server

SQLBits 2022 – Levelling up my Performance Tuning skills

10.03.2022 by Steven Naudet

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.

Database Administration & Monitoring

dbi Event Recap: SQL Server Automatic Tuning and Query Store

15.11.2021 by Steven Naudet

Earlier this month, dbi services hosted a free multi-technology event. Details are available on our website. I had the opportunity to present a session about the Query Store and the Automatic Tuning feature available on SQL Server and(…)

Database Administration & Monitoring

SQL Server: Is Fill Factor applied during INSERT?

13.11.2021 by Steven Naudet

The Fill factor setting controls the amount of space that is left available on the index data pages. The goal is to allow new rows to be inserted or existing ones to change size (UPDATE) without resulting in(…)