In this video, I briefly review a good book: SQL Server 2022 Query Performance Tuning by Grant Fritchey.
I can recommend, without reservation, purchasing at least one copy of this book. I could probably recommend purchasing up to 5 copies of this book but not more than that. If you have more than five copies of Grant’s book, it’ll look a little weird.