Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,476 reads
Idea for PASS Summit 2010 – Share Your Other Passions
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,389 reads
TechEd Online Interview
Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for...
2009-09-30
1,473 reads
On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,773 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,980 reads
Jack Corbett Now Co-President of oPASS
I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...
2009-09-29
1,613 reads
More on the MVP SQL Server book
If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout....
2009-09-29
1,367 reads
Impact of uninstall instance on replication.
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,665 reads
Vote for Mr. LaRock
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,575 reads
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,851 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