Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
368 reads
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to...
2009-07-07
1,850 reads
SQLSaturday Blog Launched
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
464 reads
So Now I’m Gilligan, Finally
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
493 reads
Object Grouping Best Practices: Using Schemas for Logical Separation
Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...
2009-07-06
3,498 reads
Behind on Blogging
One of the things I recommend to people that are looking to get into blogging is that they write 10...
2009-07-06
353 reads
Presenting at SQL Saturday Baton Rouge
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
489 reads
Recovering Missing Templates in Visual Studio
Recently I decided to expand my coding knowledge and picked up a Visual Basic book. I’ve been working in this...
2009-07-06
785 reads
Episode #3 It's All About The Tools TV Show
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Richmond SQL Server Users Group
Actually a combination meeting of the Richmond .NET and SQL groups, put together for me. They normally meet on consecutive...
2009-07-06
742 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 BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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