Mohammed Arshad

Interests: SQL Server , Databases and Information Systems , Blogging / Posting

Index Fill Factor

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-02-06

978 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...

Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...

Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...

Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...

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;