I'm a huge fan of SQL Server 2008 Bible by Paul Neilson. Otherwise there's plenty of info on the internet and nothing replaces self-study and practice.

Mark