Srinivas

Database mdf & ldf files size, used space, Free space in MB

This script will help to get the Database mdf & ldf files size, used space, Free space in MB.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2025-02-27 (first published: 2025-02-25)

399 reads

A cryptic message, a book cipher hidden in art provenance records, and a trail...

A customer was trying to compare two tables and capture a state as a...

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       NULL

What is returned when I run this code:

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