Some 24 Hours of PASS Sessions Can Now be Viewed Online
If you missed out on some of the 24 free, live sessions that made up the 24 Hours of PASS,...
2009-09-09
493 reads
Blog Posts
Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
305 reads
Spools in Execution Plans
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,807 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,018 reads
Struggling with C#
I taught myself programming with Quick Basic (started with Turbo Basic but couldn’t find a book on it, so bought...
2009-09-09
370 reads
Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-09-09
3,636 reads
Date Expression Compilation in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,632 reads
I’m going to Disney World! (Well, to SQL Saturday Orlando)
I’m going to Disney World! At least that’s what my kids will think when I tell them that I’m heading...
2009-09-08
320 reads
Identity Insert Guideline
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
602 reads
Importing SQL Server 2008 Analysis Server Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
595 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
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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