Inline TVFs can't use FORCE ORDER hint but Multi-Statement TVFs can...?
Doing some work with converting Multi-Statement TVFs to Inline TVFs and I'm finding that the Inline TVFs cannot use the...
2011-11-08
686 reads
Blog Posts
My Playbook For Putting On a SQLSaturday Part 1
The Long Road
I am going to post this as a series covering, in detail, everything humanly possible about the logistics...
2011-11-08
1,286 reads
PASS Board Of Directors Interview
I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...
2011-11-08
634 reads
Quite a salary
If this article is true, and I suspect it is for some software engineers, why aren’t more people learning programming?
I...
2011-11-08
1,065 reads
SQL Saturday #99 Minnesota on Friday 11/11/11
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
405 reads
SQL Server security webinar now available on-demand
Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...
2011-11-08
1,167 reads
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,793 reads
T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
5 reads
T-SQL Tuesday #024: Prox ‘n’ Funx
I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches. Fortunately...
2011-11-08
662 reads
What #SQLFamily Means To Me
Meme Monday, What #SQLFamily means to me personally.
Tom LaRock Is kicking of November with this particular meme. I’m not sure exactly...
2011-11-08
846 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