spid in Killed/Rollback cannot kill
We come across a situation where we have to kill one spid which was running for quite some time, so...
2011-12-17
3,560 reads
Blog Posts
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...
2011-12-17
1,390 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....
2011-12-17
5 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is...
2011-12-17
704 reads
Why you may or may not consider using Database Snapshots!
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,263 reads
Counting Merge Replication Article Changes
One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding...
2011-12-16
2,037 reads
Factless fact table
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,639 reads
Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
2,050 reads
My first blog post!
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
536 reads
Open_transaction_count in sys.dm_exec_sessions
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,393 reads
Blogs
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers