LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
513 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
539 reads
Congratulations to MVP Grant Fritchey
Announced today on his blog at http://scarydba.wordpress.com/2009/04/01/mvp/. Well earned in my opinion between his participation with PASS, SSC, and his...
2009-04-01
421 reads
Congratulations to Grant Fritchey
He was awarded MVP status today, no joke, for his work in the community.
According to his blog, it’s not a...
2009-04-01
940 reads
Moving to MySQL
It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software....
2009-04-01
492 reads
bedpost - It's Business Time
Further off topic than usual, but I ran across this as I browsed Springwise after a friend suggested it might...
2009-04-01
592 reads
Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,473 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,439 reads
Lunch in Town
One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed....
2009-03-31
1,815 reads
Microsoft Project Migration Template for the move to SQL 2008
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,825 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