I recognize that Kalen Delaney's book, SQL Server Internals, can be pretty advanced, but it's the kind of thing you read over and over again to build up knowledge. It's not great for moment by moment troubleshooting, but when you're trying to figure out how something works in order to prevent an error.

And Jonathan's book.