Time’s Makin’ Changes
Some History Almost exactly 7 years I ago my wife and I decided to apply to be missionaries with New Tribes Mission. We decided at that time to...
2011-02-03
4 reads
Blog Posts
Time’s Makin’ Changes
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
786 reads
What SQL Server Service Pack Do I Have Installed?
If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...
2011-02-03
853 reads
Who Changed Jobs in 2010?
Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...
2011-02-03
539 reads
A Full Backup can Impact a Log Backup–MCM Prep
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-02
2,927 reads
A Mish Mash of Stuff
I don’t generally post bits of this and that, but I’ve accrued a few things that I wanted to share,...
2011-02-02
601 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,931 reads
Meet Me In Florida!
While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.
I’m not just...
2011-02-02
748 reads
PASS Summit Location
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...
2011-02-02
1,916 reads
2011-02-02
9 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