This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
454 reads
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
628 reads
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,538 reads
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
8,288 reads
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
450 reads
I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but...
2016-01-14
1,783 reads
By Steve Bolton
…………Throughout most of this series of amateur self-tutorials, the main topic has been and will continue to be...
2016-01-25 (first published: 2016-01-13)
1,972 reads
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,229 reads
Code Coverage
What is code coverage?
When you write some code and then test it, how sure are you that you have...
2016-01-22 (first published: 2016-01-13)
2,074 reads
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives...
2016-01-13
15 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