SQL Server 2012 (“Denali”) Licensing
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,509 reads
Blog Posts
System Reserved Partition and monitoring
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,038 reads
With A Little Bit of Care, You Can Use the DMVs to Auto-Create Some Missing Indexes, Here Is How (but with Caveats)
An Automagic Index Creation Script? No, but a start to deal with Missing IndexesHere's the useful join from a number...
2011-12-02
2,006 reads
Workarounds for SSRS 2008 Font rendering issue
Problem
A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed...
2011-12-02
5,971 reads
Database Mirroring In A Windows Workgroup
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,730 reads
DBA in Space: Behind the Scenes—Question 9
This is a continuation of my DBA in Space journal.
Episode nine was filmed in the “Mars” exhibit. In this scene,...
2011-12-01
629 reads
December Question: When reflecting on this year, what has gone well, and what would you do differently?
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,177 reads
PASS Update #67
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
432 reads
PASS Update #67 (Election)
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
641 reads
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
563 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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