An interesting setting for NULL but don’t use it for future TIP #109
As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for...
2015-08-09
556 reads
As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for...
2015-08-09
556 reads
I hope all of you aware of User define table type (a table value parameter) which we discussed earlier in...
2015-08-08
1,358 reads
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
15 reads
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...
2015-08-14 (first published: 2015-08-07)
2,243 reads
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
26 reads
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
507 reads
Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...
2015-08-07
722 reads
Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...
2015-08-07
507 reads
Recently I had to create a new business intelligence project at a client. However, there was no source control present....
2015-08-07
2,558 reads
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
407 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 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