SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,640 reads
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,640 reads
For T-SQL Tuesday #111, Andy Leonard asks “What is your why? Why do you do what you do?”
Like Andy, I...
2019-02-12
666 reads
This month for T-SQL Tuesday we are asked to describe our “Why”. I have a couple of Whys not related...
2019-02-12
677 reads
This month's T-SQL Tuesday is hosted by Andy Leonard (blog/@AndyLeonard) and his topic was this:
That’s the question this month: Why...
2019-02-12
124 reads
This month’s T-SQL Tuesday is hosted by Andy Leonard at andyleonard.blog . Andy asks us, what is your “Why?”
So what is...
2019-02-12
686 reads
In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...
2019-02-12
13 reads
Would you believe that it is already the second Tuesday in February? Wow, this month is sure going fast. But...
2019-02-12
187 reads
In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...
2019-02-12
12 reads
This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I...
2019-02-12
686 reads
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently...
2019-02-12 (first published: 2019-01-23)
2,163 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
Comments posted to this topic are about the item 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