How Stable is SQL Server 2005?
I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with...
2008-02-19
1,532 reads
A Welcome Delay
I get a bit of a delay in working on the set down in the basement thanks to the weather....
2008-02-19
1,402 reads
Ideas for Managing Cables
I had to run all the cables for all the machines in our classroom recently and you know how messy...
2008-02-18
1,461 reads
SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Management Article Posted on SSC
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for...
2008-02-18
658 reads
Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
403 reads
Speaking updates
If you are anywhere near St. Louis next Wednesday night, I will be speaking at the St. Louis Visual Basic...
2008-02-16
512 reads
Software Engineering
Some see this as a misnomer, or even an oxymoron. Many countries don't allow "engineer" to be a title for...
2008-02-16
1,087 reads
Getting Geeks (IT Pro's) To Talk at User Group Meetings
User groups have to be about more than technical content if you want to sustain them over the long term,...
2008-02-14
488 reads
Is SQL Server Dead?
Someone sent me this note about a talk they'd had at their user group and the guest speaker mentioned the...
2008-02-14
2,258 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