Yannick Liekens

10 Aug 2022 Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you work a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with “Parameter sniffing”. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan Optimization.

02 Jun 2020 The magic of Scalar-valued function inlining in SQL 2019

For some reason developers like stuffing their SQL with SVFs, and that... makes... it... so... slow. Are SVFs really that bad? And is scalar-valued function inlining useful at all? Let’s walk through it together and find out!