Are there any really heavy duty SQL Server books on SQL that you could recommend. I need something that will explain constructing very complicated queries.. theory and things like that. I haven't come across a book that really gets into it.

Thanks