Performance

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…