Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find...
2013-10-14
1,406 reads
Two Weeks to SQL Intersection
If you haven’t made it to a conference this year, you’ve still got a great one to think about: SQL...
2013-10-14
743 reads
Last Weeks Top “Reading” Links #53
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-14
769 reads
PASS Summit 2013 Report #1
Yesterday we drove up from Charleston where I had attended SQLSaturday #227. It’s not a bad drive, about three hours....
2013-10-14
316 reads
Networking Dinner at the 2013 PASS Summit–Tonight!
Tonight for the fourth year Steve Jones and I are hosting an informal networking dinner. We’ll be at Buffalo Wild...
2013-10-14
382 reads
Why you should know how to script as well as use the GUI
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out...
2013-10-14
1,018 reads
Top 11 Qualities of a DataWarehouse Implementer
Top 11th Quality: Curious to explore different designs There are many ways to achieve the same thing. Before actually getting...
2013-10-14
544 reads
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,145 reads
Colorado SQL Events : October 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring...
2013-10-13
346 reads
Colorado SQL Events : October 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-10-13
454 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