Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,530 reads
More Code Per Module = More Bugs, But More Complex Code <> More Bugs?
SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I...
2008-03-28
1,512 reads
The Shadow Knows What Procedures Lurk in the SQL Plan Cache
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,475 reads
More Thoughts on LINQ to SQL
At the recent Orlando Code Camp I had the opportunity to spend a good bit of time discussing LINQ to...
2008-03-26
1,671 reads
Getting Reporting Services to work on Vista
I recently ordered a new laptop and this one came with Windows Vista Ultimate. I knew about having to install...
2008-03-26
2,745 reads
Notes About our Raffle of the One Laptop Per Child Laptop at Orlando Code Camp
I've blogged about the OLPC project a couple times already, not as a political statement but just as a fascinating...
2008-03-24
1,370 reads
Orlando Code Code Follow Up
Although attendance was down this year (around 280 attendees) due to it being held Easter weekend, I thought this was...
2008-03-23
1,434 reads
Writing a course
Over the last three years, since that first article I submitted to SQLServerCentral, I find myself getting involved in more...
2008-03-21
1,302 reads
Orlando Code Camp Reminder & A Special Raffle - One Laptop Per Child
Reminder that if you're registered the Orlando Code Camp is tomorrow. If you're registered and plans have changed, please cancel...
2008-03-21
1,596 reads
Denver Heros Happen {Here} Launch
I went down to the Denver stop on the Heros Happen Here launch events and as you can tell by...
2008-03-20
1,735 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