Replication Latency
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...
2013-01-25
2,080 reads
Chris McGowan
SQL Server 365 - Fantastic First Year In Numbers
So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has...
2012-12-31
1,381 reads
Active Directory Group Membership and Powershell
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
836 reads
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,216 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,538 reads
Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,547 reads
Database Mirroring Performance Counters
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t...
2012-11-21 (first published: 2012-11-14)
2,723 reads
Database Mirroring Error
I have been setting up multi instance database mirroring for the last couple of days along with some other DR...
2012-10-26
649 reads
Create Database Script
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...
2012-09-21
1,212 reads
tablediff Utility
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,721 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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