oPASS Meeting Notes
We had our final meeting of the year last night, minutes posted here. Pretty good turn out, 22 total. And...
2007-12-19
1,437 reads
User Group Meeting Checklist
I'm a fan of lists so that I stay on track rather than trying to remember all things at the...
2007-12-18
1,422 reads
The Podcastee
Usually I'm the one working on my podcasts and starring in them. However I got invited to participate in and...
2007-12-18
1,434 reads
Strategic vs Tactical Time
As an owner of a small business one of the constant struggles is time management, and more importantly, finding time...
2007-12-17
1,488 reads
Turning Off Logging
I'm sure that most of you know that you cannot turn off logging in SQL Server. You can minimize the...
2007-12-17
1,436 reads
Lists of Tools
I ran across this list of interesting tools by Scott Hanselman and there is some good stuff to look at...
2007-12-14
1,360 reads
Google Knol As Community Competitor?
I ran across this in the Google bloghttp://googleblog.blogspot.com/2007/12/encouraging-people-to-contribute.html announcing a new beta feature called Knol that allows an author to...
2007-12-14
1,674 reads
Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,592 reads
12000!
A short congratulations to myself. I was answering posts last night after tech editing another chapter of the book I'm...
2007-12-12
1,475 reads
Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,395 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