Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.