SQLYSE with Pankaj Manek

In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....

2015-09-07

1,336 reads

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...

2015-08-20

3,803 reads

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...

2015-07-31

10,544 reads

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

Fabric has CI/CD built in, but if you've tried to use it for database...

attriage – n. the state of having lost all control over how you feel...

WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571

WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119

WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;