Performance

SQL Server 2025 is out at last and we are continuing our journey into some of the new features this version brings.

The latest version of SQL Server continues to evolve some of the features we first saw in SQL 2022 and one of those features is ‘DOP Feedback’…

I have finally started looking deeper into some of the new features of SQL Server 2025 and this post will cover the first of many planned posts around all that is new and shiny within SQL 2025

I just love it when there are new features to dive into and explore…

In the previous post, we covered the basics of parameter sniffing with a simple demo to show what actually happens.

We took a basic stored procedure and illustrated how the first plan to get cached can have severe performance implications…

A while ago, I was working with a client who was experiencing performance issues on SQL Server 2019.

We quickly isolated the problematic procedure and they asked ’this normally runs fine, why is this a problem now?’ A fair question…