Purpose This blog and bullet journal was specially created to help me with my tendency to have suicidal ideation, depressive, and manic episodes related to
The post Mental Health Bullet...
2022-09-19 (first published: 2022-09-06)
273 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-06
23 reads
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
342 reads
On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had...
2022-09-12 (first published: 2022-09-05)
181 reads
The problem
There was a need to make changes to a table with an Indexed View. Since Indexed Views must be created with SCHEMABINDING, the View must be dropped and...
2022-09-19 (first published: 2022-09-05)
339 reads
The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...
2022-09-05
22 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-05
25 reads
I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the...
2022-09-16 (first published: 2022-09-02)
181 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-02
24 reads
If you’ve never used Linux before, you might wonder how to manage a database on a server. Managing a database can be simple or complex, depending on the needs...
2022-09-16 (first published: 2022-09-01)
263 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
Comments posted to this topic are about the item 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