Tag Archives: Performance

T-SQL Tuesday #200: When I Look at a Query …

Posted on July 7, 2026 by way0utwest

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog party events a year. 200 means this has been running for … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

When Do We Worry About Scalability?

Posted on September 18, 2024 by way0utwest

“We need to get the code written for feature X. Can you finish this query today?” We’ve all heard some variation of that request. We have a request or demand, and we need to get it done. We need to … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Invisible Downtime

Posted on May 22, 2024 by way0utwest

This article has a concept I’ve never heard about: invisible downtime. This is the idea that there are problems in your application that the customer sees. Your servers are running, but the application doesn’t work correctly or is pausing with … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Invisible Downtime

Be Careful with Missing Index Requests

Posted on December 4, 2023 by way0utwest

One of the things that has been interesting to watch over time is how the SQL Server platform has expanded the amount of information that we get back about the performance of the query optimizer and query processor. While it’s … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Be Careful with Missing Index Requests