All Offices Should Have A View (Or At Least Windows)
Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for...
2009-10-08
330 reads
Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for...
2009-10-08
330 reads
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
600 reads
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
726 reads
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-08
1,550 reads
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,401 reads
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
789 reads
I’ve been a regular speaker at the DevTeach/SQLTeach events in Canada for the past several years. Jean-Rene Roy and his...
2009-10-08
446 reads
We've been doing video conference calls for work through LiveMeeting for a few months. After two years of audio only...
2009-10-08
613 reads
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-08
9,653 reads
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
2009-10-08
565 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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