When it comes to SQL Server, my favorites are the SQL Server internals and development books put out by the MS Press and done by Kalen Delaney and Itzik Ben-Ghan with each release. Kalen will tell you how SQL Server truly works and Itzik will show you how to write professional code for it. These books are dense and technically heavy and I would not recommend them for every one. If however you do have an attention span that is measured in hours instead of the average american attention span of 8 seconds, then I would give them a try.
Originally Posted by VLOOKUP
If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.