I am in the process of improving performance on our database application. While I am not a DBA, I am pretty comfortable with SQL. I am after a book that can help me understand how queries written in different ways affect performance and also understanding things like table scans, indexes an statistics.
I don't just want to blindly add everything the tuning advisor says so I am looking for the knowledge required to assess these recommendations in the context our environment and how to fully utilise the tools available. I am working with MSSQL2008+ so a book the utilises this environment specific would be good.
Thanks in advance