Gail Shaw

  • Interests: Computer Graphics, Aikido, Roleplaying

All authors

Blog Post

Upcoming conferences

It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy...

2016-04-26

6 reads

Blog Post

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...

2016-03-02 (first published: )

2,359 reads

All authors

Blogs

T-SQL Tuesday #202: 100 Hours

By

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform

By mehul.bhuva@gmail.com

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

The Costs of Multiple Platforms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs of Multiple Platforms

RegEx Functions II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions II

Visit the forum

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.COM
If 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