Amazon.com Author Central Page
If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The...
2009-10-28
610 reads
Replication Setup:
I saw too many questions on forum asking step by step process of configuring replication I have these links in...
2009-10-28
1,138 reads
2009-10-28
576 reads
Snags With Profiler GUI
Running the Profiler GUI against a production server is not something you should do. I’ve outlined my research into exactly...
2009-10-28
878 reads
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,865 reads
My Schedule for the PASS Summit 2009
For the most part, I have an easy schedule. I’ll be in the 600 hallway most morning after the keynote...
2009-10-28
728 reads
How Many Rows Have Changed?
One of the things that I've asked DBAs, and I see asked often, is how much does your data change?...
2009-10-28
2,484 reads
My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-27
1,212 reads
2009 PASS Community Summit and SQL Server Connections Conference, Both in November
If you will be attending either the 2009 PASS Community Summit in Seattle, WA, from November 2-5; or the SQL...
2009-10-27
440 reads
Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com
While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questions answered, and to participate...
2009-10-27
823 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