SQL Rally Performance Tuning SSAS Session
Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning...
2011-02-16
1,235 reads
Blog Posts
Windows Server 2008 R2 SP1 Released and Installed
Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier...
2011-02-16
1,532 reads
Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,483 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that he’s not the origin of it. Whoever said it had...
2011-02-15
13 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that...
2011-02-15
834 reads
DWH Workshop material
As announced in my DWH workshop in Munich, you can find here my
whole ETL solution. Thanks for attending my workshop...
2011-02-15
795 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
485 reads
MagicPASS February 2011 Meeting
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
535 reads
More info on nested views causing performance problems
As if I needed any further convincing that nested views were bad....
The other day I had to write a particularly...
2011-02-15
1,184 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
715 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 Cijerah WA {08218154393}
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Alamat Kontak BCA KCU BANDUNG WA {08218154393}
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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