DevTeach/SQLTeach Montreal 2011 Registration is Now Open
The recently resurrected DevTeach/SQLTeach event will be held May 31 through June 2, 2011 in Montreal, Canada at the Montreal...
2011-01-10
650 reads
Blog Posts
Fun with Extended Properties in SQL Server 2008
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty...
2011-01-10
3,398 reads
How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,373 reads
My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,405 reads
PASSMN Call for Presenters and Sponsors
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
415 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting: Why I Use Stored Procedures With the...
2011-01-10
8 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting:
Why I Use Stored Procedures
With the proliferation...
2011-01-10
772 reads
SQLBits Will be Held in Brighton England in April
SQLBits, the largest SQL Server conference is Europe, will be held this April 7-9, 2011 in Brighton, England at the...
2011-01-10
562 reads
SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...
2011-01-10
14,906 reads
SSC Editorial: Clouds in our Future
I wrote Clouds in our Future to see if I could spark a good conversation about the mental shift required...
2011-01-10
608 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