What is the good literature on optimizing sql queries (MS SQL)?

Question

SQL

Please, tell me
Here's the situation:
On Sql-ex.ru, I solved a fairly large number of tasks, even received the first certificate. I mastered various sql constructs, which turned out to be very handy in real work. But when I compare the effectiveness of my solutions with the solutions of other people registered on the site, I see that the execution time of their requests is about 5 times less.
The most general principles of optimization are clear (fewer subqueries, instead of * only the necessary fields, limit the selection to TOP, etc.), but I would like some systematized information with examples and a description of the subtleties.
Googled on the topic "Optimization of sql queries", found some fragmentary information and a holivar topic on sql.ru.
And in the end, all the same, a subject, I would like some book where it is written quite systematically how to read and analyze the query plan correctly and how to optimize the query correctly.

Answer 1

Karvin B. - Programming SQL databases. Common Mistakes and How to Eliminate Them - 2012 see this book