What books on MS SQL Server or MS T-SQL contain the most complete information?

Question

Books

Bookstores are full of books like
Microsoft SQL Server Administration or Microsoft SQL Server
Application Development.
In these books, various analyzes and methods of server administration are given, while the t-sql language itself is given in part and very briefly.
I would like to find a handbook on T-SQL syntax, preferably with examples of its application (how to do it right / how to do it wrong / how to do it better) for MS SQL Server 2008. What can you advise?
In addition, you often have to look for information about service tables/commands (sys, msdb, etc.) to check the existence of objects on the server and create them using queries. In what books can you find the most complete description of such objects and examples of their use?