SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

13,367 reads

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,962 reads

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,368 reads

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,989 reads

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

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

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

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

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

Comments posted to this topic are about the item 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)