I have recently experienced an issue with a third-party backup application (Commvault) that was trying to backup the databases from...
2016-05-09
3,346 reads
When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...
2016-05-09
52 reads
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,649 reads
It’s Monday morning (er afternoon) and it’s time for this week’s blog and twitter round-up for last week. If you...
2016-05-09
495 reads
I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...
2016-05-09
1,133 reads
Everything ran smooth The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free...
2016-05-09
531 reads
Looking forward to the BRSSUG/BRPBIUG meeting this Wednesday night May 11, I'll be giving a presentation all about SQL 2016!
This...
2016-05-09
377 reads
Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...
2016-05-09
1,018 reads
Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...
2016-05-09
401 reads
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share...
2016-05-08
166 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