Gaps and Islands Across Date Ranges
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
6,702 reads
Blog Posts
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
31 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
3 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
8 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data...
2019-03-12
410 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
11 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
16 reads
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for...
2019-03-12
14 reads
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
386 reads
TSQL Tuesday #112 – Dipping into the Cookie Jar
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
237 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
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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