Finding Bad Queries
Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.
2026-08-03
276 reads
Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.
2026-08-03
276 reads
Steve asks if we should focus on the slowest queries or tackle other issues in our systems. Or if we should even have to make these decisions.
2026-07-31
201 reads
Learn about implicit conversions, which can dramatically affect the performance of your workload.
2026-07-17
3,611 reads
Built the index, but SQL Server still scans the whole table? Learn how to read execution plans and find exactly why your index is being ignored.
2026-05-18
3,393 reads
In theory, SQL Server performance monitoring is pretty simple: 1. Review the server’s top wait types, 2. Find the queries causing those wait types, 3. Fix those queries, or improve the way the server reacts to them (indexes, settings, etc.). But in practice, step 2 is awful because:
2026-05-13
The short answer: in the real world, only the first column works. When SQL Server needs data about the second column, it builds its own stats on that column instead (assuming they don’t already exist), and uses those two statistics together – but they’re not really correlated.
2026-04-29
The magic way to get better performance from your system is to write better code from the start.
2026-04-22
200 reads
Monitoring and alerting can be overwhelming tasks, especially for those new to the world of managing production data. One common challenge for any data professional is the identification and management of queries that run for longer than they should.
2026-03-09
In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.
2026-02-06
2026-01-30
492 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