It’s always parameter sniffing (Part 2): SET options
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,522 reads
Blog Posts
Learn about the State of Database DevOps Next Week
It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...
2019-02-14
229 reads
Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
132 reads
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
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
221 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
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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