Impact of uninstall instance on replication.
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,665 reads
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,665 reads
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,575 reads
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,851 reads
Thanks to everyone who attended my SQL Server Reporting Services class in Nashville over the last couple of weeks. As...
2009-09-29
1,590 reads
I’ve been reading through this book and it really does have something for everyone at any level.
I think it...
2009-09-29
1,460 reads
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use...
2009-09-29
1,830 reads
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,738 reads
create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
@id int
as
insert MyTable select @id
insert #test select...
2009-09-29
1,697 reads
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....
2009-09-28
952 reads
OK, there was something that Microsoft did to tick me off. SQL Server 2005 introduced us to so many exciting...
2009-09-28
6,198 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