SQL Server 2005 Replication bug?
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
929 reads
Blog Posts
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
495 reads
Hot Subtract
Over the last few weeks I've seen a few posts about the new Hot-Add CPU feature in SQL Server 2008....
2008-01-14
795 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
914 reads
On the Importance of Documentation...
It seems that I keep inheriting old systems that provide a singular, albeit mission critical, function to their owners. In...
2008-01-09
539 reads
Sometimes You Need an Analog Solution, Sorta - Earth Class Mail
Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so...
2008-01-09
499 reads
SQL Injection, Again!
Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in...
2008-01-09
630 reads
Partitioning Part 3 Posted on SSC
Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in...
2008-01-08
259 reads
ACM Queue Article about One Laptop Per Child
If you happen to read ACM Queue there is a great article in the Nov/Dec 2007 issue called 'A Conversation...
2008-01-07
280 reads
A Lower Level of Noise
I finally got set up to access the MVP newsgroup server today while I was working on some other projects....
2008-01-06
789 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kontak Bank BCA KCP Cijerah WA {08218154393}
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Alamat Kontak BCA KCU BANDUNG WA {08218154393}
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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