24 Hours of PASS was an Adventure
On July 21, just a few short weeks ago, I got an e-mail from Rick Heiges, who is on the...
2009-09-02
657 reads
Blog Posts
Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
746 reads
Building a Better Blog
I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well...
2009-09-02
642 reads
Data Type Synonyms
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
639 reads
Finally Migrating from SQL 2000
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
427 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,448 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
450 reads
Nice Discounts On Microsoft Certification Exams From Prometric
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
601 reads
SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
634 reads
SQLSaturday #21 Schedule Announced
Jack Corbett sweated over the schedule, not easy to decide what sessions to use and where to put them, but...
2009-09-02
328 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