Undocumented use of the Columns_Updated() function
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
628 reads
Midlands PASS Chapter - August 2, 2007
"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software
The Midlands PASS Chapter...
2007-07-31
1,563 reads
User Groups Moved to New Domain
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,556 reads
ApexSQL's Industry Experts program
If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it...
2007-07-25
1,732 reads
SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
What is BI?
I actually started writing an article on this, but it's been sidetracked with travel and other stuff. However I do...
2007-07-21
1,477 reads
A Graphical View of the Physical Allocation of a Database
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,656 reads
More Navigation
I've looked at the daily newsletter for a year now and I've wondered about the table of contents. It seems...
2007-07-19
1,402 reads
Tampa Code Camp - Again
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,371 reads
New version of SQL Server 2005 Best Practices Analyzer available
If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for...
2007-07-17
1,717 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