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,165 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,602 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,344 reads
2010-11-17
3,186 reads
2010-10-05
3,096 reads
2010-09-15
3,138 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,796 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,786 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
668 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,008 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers