My Dad told me when I was quite young that "Half of all that is written is wrong and the other half is usually written in such a fashion that you can't actually tell".
With that, I'll say that I've long had a serious mistrust of anything written, especially from people who write about SQL. That includes the "Official Documentation". Unfortunately, I didn't mistrust enough when it came to that documentation and it took me for a ride (like it did with more than 99% of the world for "Best Practice Index Maintenance" that I've not yet finished researching but I have proven that it was seriously wrong. As a result, I have zero trust in anything published on BBFAATT (another "Moden-ism" pronounced as "B-B-Fat" where the "Fat" may also be bleated as a goat might... or not and stands for Books, Blogs, Forums, Articles, AI, 'Tubes, and Talks).
This is especially true when it comes to "AI". It has failed to produce answers that actually work and have no performance issues for every simple but non-beginner questions that I've asked it. It couldn't even solve the problem of 10+10x10-10 properly.
So, while a whole lot of things have gotten better in this world, my trust in "expertise" has made flushing sounds and the advent of AI (especially with its ability to easily construct deep-fake pictures and 'tubes) have produced the final gurgle in the trust toilet.
That doesn't stop me from observing BBFAATT but I have no trust in it, whether it's for SQL or anything else. Instead, I use it as motivation to prove things, one way or the other.