1. there's the Stairway series on here.
2. Itzik's T-SQL Fundamentals and T-SQL Querying
Anything else I should read? I'm thinking a good bit on how data gets retrieved (so indexing).
I used Jonathan Kehayis's (I think) code to "explode" AdventureWorks, so if I write a really bad query, it takes forever to execute. (I know, it's a case of baselining, which I should definitely practice).
I'm tempted to read some of the Querying book on certification only to be sure that I cover everything. (Yeah, I have some old certs, and I think they're not worth the paper they're printed on)..