Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
305 reads
Be Careful of Facebook
Even the President thinks so! In his talk yesterday, he warned kids about Facebook, and being careful what they should...
2009-09-09
1,066 reads
Great Post on Clearing all data from your Data Warehouse
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
421 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,018 reads
Books You Should Own
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
457 reads
Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-09-09
3,636 reads
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-08
715 reads
Transaction replication info
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
734 reads
Replication troubleshooting.
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
672 reads
Importing SQL Server 2008 Analysis Server Database
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
595 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