Walking the Line
I have the best job here at SQLServerCentral.com. I work from home, I get to be creative, writing about what...
2007-06-28
1,376 reads
Debugging Stored Procedures in VS 2005
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,377 reads
Keep a Spare
I wanted to get working on Katmai a little, but not being brave and seeing the release notes that it...
2007-06-20
1,357 reads
Back to Work (Some days it flows)
My job here at SQLServerCentral.com is mainly as editor. This means that for the most part I edit articles, schedule...
2007-06-20
1,423 reads
Celko Cites Steve Jones
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL...
2007-06-20
1,417 reads
A Motivational Quote
Normally I don't post this sort of thing to my blog, trying to focus on more technical matters, but this...
2007-06-19
1,686 reads
GO More than Once?
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,379 reads
Gartner Developer Conference
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to...
2007-06-13
2,005 reads
Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,345 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,329 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