Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...
2018-11-13
7 reads
Blog Posts
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when...
2018-11-13
1,012 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL...
2018-11-13
347 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...
2018-11-13
5 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...
2018-11-13
5 reads
Deploying SQL Server Availability Groups in Kubernetes
In this blog post, we’re going to work on deploying a SQL Server Availability Group in a Kubernetes Cluster in on-premises virtual machines. I’m going to walk you through...
2018-11-13
12 reads
Deploying SQL Server Availability Groups in Kubernetes
In this blog post, we’re going to work on deploying a SQL Server Availability Group in a Kubernetes Cluster in...
2018-11-13
1,948 reads
Drive space check SQL server steps and scripts
AdvertisementsFollowing is the script used for drive space related issues.
--SQL 2000
-- select name,(size/128.0) as size_mb,* from master.dbo.sysaltfiles order by size_mb...
2018-11-13
648 reads
How Much Will Compression Really Gain Me?
Did you know compression can gain you more than just space on a disk, it can allow you to fit...
2018-11-13 (first published: 2018-10-31)
2,628 reads
Steps to Create an In-Memory table for SQL Server
Creating a table to be in memory compared to standard tables that use the files on disk can have several...
2018-11-13 (first published: 2018-10-31)
7,740 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 BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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