Troubleshooting Slow Queries That Already Have an Index (2026-11-02)

• Troubleshooting Slow Queries That Already Have an Index
• What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)
• From the SQL Server Central Blogs - How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
• From the SQL Server Central Blogs - Monday Monitor Tips: Query Recommendations
• SQL Server 2022 Query Performance Tuning

• SQL Server Vector Support II

Great Things

"Great things are done by a series of small things brought together.” – Vincent van Gogh, Dutch Post-Impressionist Painter.

I ran across this quote recently and it struck me that it's expresses a thought I've had for some time. Instant, magical success isn't often what it appears. Anyone that seems to have sprung up overnight with success in anything has often spent a lot of time getting ready.

Outside of lottery winners, of course. If you bought a ticket, that's instant success. Unless you buy a dozen every week, then you've likely been doing your own (poor) preparation over time.

Whether it's software, sports, business, anything that takes off, goes viral, or suddenly catches the public's collective eye is the result of a lot of small things. Practice, learning, continuous improvement. It's a formula that works in music, in sports, in manufacturing, and in software.

Perhaps the most important part of this quote is the ending. Things have to be brought together. In software, we work in teams, and we have to coordinate and collaborate. Whether with other human developers, AI agents, or Operations. We have to learn to ensure our efforts, our knowledge, our evolution works together. This might be especially important in ensuring database and application code changes mesh well. That's becoming a concern for more organizations, and more management that realizes that the database has to become a part of the software development life cycle. Either developers need to learn more, or work closer with database staff.

We can do great things, we can build amazing systems, but it takes effort, and it takes teamwork.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

Imran2629 from SQLServerCentral

This article looks at some common query patterns that cause performance issues and provides some guidance on how to fix them.

Additional Articles from SimpleTalk

Grant Fritchey walks through a real troubleshooting saga – using Wine, a shim DLL, a misconfigured registry entry, and a lot of trial and error – to get a BridgeCom Maverick radio’s Windows CPS running on Linux Mint.

Joyful Craftsmen from Joyful Craftsmen Blog

Your AI is busy. But do you know what it's worth? Most companies can tell you how much AI they use. Few can say what it's worth. Here's how...

Steve Jones - SSC Editor from The Voice of the DBA

We keep adding stuff to Redgate Monitor, and it’s easy to miss some of the improvements. Here’s one that’s been around quite awhile, but while discussing the product with...

Grant Fritchey from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

Today's question (by Steve Jones - SSC Editor):

Think you know the answer? Click here, and find out if you are right.

Here's a few of the new posts today on the forums. To see more, visit the forums.