When Do We Worry About Scalability?
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
2024-09-18
143 reads
Performance and Tuning
SQL Local Variables and Performance Issues
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
2024-08-23
Invisible Downtime
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
2024-05-22
218 reads
SQL Server Plan Cache Bloat Performance Impacts
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
2024-04-10
Option Recompile is a Magic Turbo Button That Actually Works.
Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
2024-04-08
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each SPID calc the execution plan, one after the other after waiting for the prior SPID to finish?
2024-03-29
2024-03-25
485 reads
2024-03-11
458 reads
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
2024-01-29
411 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers