I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
661 reads
Blog Posts
Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM...
2011-02-12
861 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs. I’m not arguing whether or not NULLs in a...
2011-02-11
6 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-11
874 reads
Book Review: Packing for Mars
Packing for Mars by Mary Roach ($15 @ Amazon) is a ton of fairly interesting trivia about the space program, space...
2011-02-11
735 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
906 reads
Colorado Speaking Tour
Next week, I’ll be making a swing through central Colorado on a working vacation of sorts. I met up with...
2011-02-11
533 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
481 reads
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
2011-02-11
3,095 reads
Pragmatically Yours Day 2 – Our Team
One of the things I’m most proud of at our company is our team.You can see some of our team...
2011-02-11
708 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 Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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