Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...
2023-07-24 (first published: 2023-07-05)
540 reads
As part of my effort to inform people on how to use tools with their disabilities and continue working, I created a series of videos that demonstrate how I...
2023-07-14 (first published: 2023-07-05)
143 reads
I was on the Data Exposed: MVP Edition show recently, talking about SQLCMD. I’ve written a few articles on the topics as well, and a blog post about setting...
2023-07-05
39 reads
I am excited to announce that I have been selected to speak for the Future Data Driven Summit 2023. This is a free online conference, on Wednesday, 27-September-2023, for...
2023-07-03
41 reads
I am super excited to announce that I have been selected to speak at SQL Server Live! in Orlando in November. I have selected to present two sessions, which...
2023-07-03
18 reads
licotic – adj. anxiously excited to introduce a friend to something you think is amazing – a classic album, a favorite restaurant, a TV show they’re lucky enough to...
2023-06-30
35 reads
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post....
2023-07-12 (first published: 2023-06-29)
568 reads
I’ve had to type a few non-English characters lately, and this blog talks about how to do this. Another post for me that is simple and hopefully serves as...
2023-06-28
434 reads
As I have mentioned in a prior blog post, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering...
2023-07-14 (first published: 2023-06-28)
693 reads
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2023-06-28
156 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
Comments posted to this topic are about the item 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