Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.
2026-09-28
2,541 reads
This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.
2026-09-28
2,541 reads
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.
2026-07-10
3,175 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If 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