SQL Server Clustered Index Seek Operation Generates Poor Query Performance
In this article, we look at why a SQL Server clustered index seek operation might not always be the most optimized approach for executing a query.
2024-02-28
In this article, we look at why a SQL Server clustered index seek operation might not always be the most optimized approach for executing a query.
2024-02-28
2024-01-29
420 reads
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
12,253 reads
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.
2023-12-06
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.
2023-11-06
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.
2023-10-30
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
2023-10-16
This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.
2023-07-10
3,901 reads
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.
2023-06-21
4,984 reads
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
399 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers