More Free Training Resources
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,256 reads
Blog Posts
My next republished article is now available
Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com. This article compares two methods...
2009-09-21
1,257 reads
One Too Many Plates Spinning
I’ve written here and there about my attempts at time management and the idea that as you spin more and...
2009-09-21
604 reads
Random Thoughts for Monday..
Hi, all! Hope everyone had a great weekend!
I was preparing my Blog for today on a subject I believe...
2009-09-21
479 reads
South Florida Code Camp Announced for 2010
Just received a note from Dave Noderer that the 2010 South Fla Code Camp will be February 13th in Mirarmar,...
2009-09-21
531 reads
TSQLScripts.com – Script of the Week
After about 3 weeks of digging through .css files and html code I finally found the problem with the site. ...
2009-09-21
509 reads
Upcoming SQL Lunch (Live Meeting) – Historical DMV Information
The next SQL Lunch is scheduled for Monday, September 28. See below for details
Date: 9/28/2009
Time: 11:30 AM
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend
Presenter: Thomas...
2009-09-21
478 reads
Windows Tip - PAE - did you know that.....
Everyone remembers that in 32-bit windows architecture, in order for SQL Server (2005) to address more than 4GB of memory, one...
2009-09-21
899 reads
Follow Up To The Boss Is Always Right
My friend Kevin had sent this to me after I wrote The Boss Is Always Right but before it was...
2009-09-20
701 reads
Intel Westmere-EP Screenshots
CPUID.COM, which hosts the wonderful CPU-Z utility, has a post up that shows where someone has taken a screenshot of...
2009-09-20
777 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