Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
187 reads
Blog Posts
Careful with Session_Context()–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-02-13 (first published: 2019-01-24)
2,218 reads
Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-02-13
11 reads
Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more!...
2019-02-13
130 reads
Free SQL tuning tool: How’s My Database?
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
220 reads
Partitioning 2: Getting and measuring partition elimination
In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.
Adding the partitioning...
2019-02-13
1,672 reads
Proposed SQL Server defaults: cost threshold for parallelism
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
194 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
21 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
114 reads
Speaking Internationally at SQLBits
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
185 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 Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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