SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you...
2009-04-13
1,231 reads
PASS Update #9
Time has flown by since my last update, busy time at work and struggling to get that done and find...
2009-04-13
394 reads
SQL Server 2005/8 Database Compression Presentation in Burlington, Vermont - April 15th
Yesterday, I drove the Smart down to Burlington/Colchester, Vermont to meet up with MVP Roman Rehak and speak to the local...
2009-04-13
1,081 reads
Networking = Business Cards
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a...
2009-04-13
825 reads
SQL Server 2008 Encryption
I'm embarking on another book project. Not writing this time, but tech editing again. I tech edited a book last...
2009-04-13
623 reads
PASS Connector Editorial For March 25, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
314 reads
What's my (fully qualified domain) name?
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,463 reads
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,425 reads
No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
796 reads
Book Review: Red Lightning
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
284 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