LINQ Again!
I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I...
2008-02-21
1,812 reads
Call for Speakers for PASS Summit is Open Through March 28, 2008
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,428 reads
New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,529 reads
Changing the Command Prompt
I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at:
...
2008-02-20
1,751 reads
Dry Erase Board v2
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,604 reads
Errata for SQL Server Certification Books
Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server....
2008-02-19
1,742 reads
SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,219 reads
How Stable is SQL Server 2005?
I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with...
2008-02-19
1,532 reads
A Welcome Delay
I get a bit of a delay in working on the set down in the basement thanks to the weather....
2008-02-19
1,402 reads
Ideas for Managing Cables
I had to run all the cables for all the machines in our classroom recently and you know how messy...
2008-02-18
1,461 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