Query Store, Plan Forcing and Table Variables
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
The...
2019-05-06
Database Performance
SQL Server Monitoring Week – SQL Plan Warnings
Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database...
2019-04-26
Why Plan Cache Scripts Can Be Misleading
A Long Way From Home Most scripts (even ones I’ve worked on!) that look at the plan cache, have had…
2019-04-26
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
The post Yes, pulling just the data...
2019-04-24
When READPAST Doesn’t Read Past
Oh, Bother Sometimes, you only wanna work on one thing. Other times, you only wanna work on something if it’s…
2019-04-24
Slightly Less Not SARGable
Date Debate Searching dates is a common enough task. There are, of course, good and bad ways to do this.…
2019-04-22
Which Database is Causing the Problem?
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first? Here are a few ways you can pick...
2019-04-17
Index scans aren’t always bad, and index seeks aren’t always great.
Somewhere along the way in your career, you were told that: Index seeks are quick, lightweight operations Table scans are ugly, slow operations And ever since, you’ve kept an...
2019-04-16
Have Your Batch Updates Become Unmanageable?
Look, I’m telling you this as a friend. Seriously, it’s time to let go of your batch updates. It’s not a...
2019-04-16
When Inline UDFs are Slower
Brent Ozar has been digging deep into new functionality in SQL Server 2019: In the Froid white paper, Microsoft talked about how they were working on fixing the function...
2019-04-15
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers