Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-18
2,190 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-17
4,743 reads
CDC Interoperability with Mirroring and Recovery
CDC Interoperability with Mirroring and Recovery
The following email came in to a discussion group last week asking several questions about...
2010-11-29
2,362 reads
2010-11-17
3,220 reads
2010-10-05
3,108 reads
2010-09-15
3,169 reads
SQL Server 2008 SP1 Too Old for Replication?
SQL Server 2008 SP1 To Old for Replication?
We are in the middle of a platform upgrade project at work, and...
2010-08-13
1,811 reads
Transferring Logins to a Database Mirror
Transferring Logins to a Database Mirror
I recently discovered that my book (Pro SQL Server 2008 Mirroring) has an older version...
2010-08-13
3,840 reads
T-SQL Tuesday #009: Beach Time: My Work Away From Work
T-SQL Tuesday #009: Beach Time: My Work Away From Work
This blog entry is participating in T-SQL Tuesday #009, hosted...
2010-08-10
682 reads
Moving to a New Blog Platform
Moving to a New Blog Platform
First, I want to say that having my blog on SQL Server Central has been...
2010-08-01
1,026 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
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