T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the...
2011-12-13
624 reads
Blog Posts
T-SQL Tuesday #025 – Tips and Tricks
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
735 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,174 reads
CPU-Z 1.59 Released
One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is...
2011-12-12
1,241 reads
More Culture-The Failure Wall
Ran across this during my daily reading, a post by Jeff Stibel on Why I Hire People That Fail. The...
2011-12-12
780 reads
Presenting at IT Pro Camp in January 2012
My first outing of the new year will be at the IT Pro Camp here in Orlando, working on some...
2011-12-12
646 reads
Replication Bookmarks
I started a list of the resources I frequent the most in the MSDN Library SQL Server Books Online - Replication,...
2011-12-12
1,111 reads
SQL Traces and c2 auditing are different
Sometimes end users interchange the terms : C2 auditing and Traces.
They server different purposes.
c2 auditing records all attempts (successfull and...
2011-12-12
844 reads
Top SSAS white papers
These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT. I’ll keep this post updated with new...
2011-12-12
5,703 reads
Working with SQL Server Third Party Vendors
I ran across Denny Cherry’s (@MrDenny) blog on Fixing Vendor Performance Problems in which he outlines three methods of dealing...
2011-12-12
1,169 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