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,179 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,701 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,347 reads
2010-11-17
3,198 reads
2010-10-05
3,103 reads
2010-09-15
3,149 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,799 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,812 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
672 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,012 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers