I worked on Oracle for a long time and supported SQL. Now I need to clear my SQL skills for a project on SQL Server 2008. Could you recommend a good resource (online / book)?
Help with books on the Internet is not so bad for SQL2008, that is, as a rule, a few examples, the syntax clearly shows. You can download it separately.
Here are three great books if you could only buy one and would like to get a link that I would recommend first
SQL Server 2008 Internal Databases http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243/ref=sr_1_1? S = books and amplifier, i.e. = UTF-8 & QID = 1330914927 & avg = 1-1
2008: T-SQL programming http://www.amazon.com/Inside-Microsoft%C2%AE-Server%C2%AE-2008-Pro-Developer/dp/0735626022/ref = pd_bxgy_b_text_b
2008: T-SQL query http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server%C2%AE-2008/dp/0735626030/ref=pd_bxgy_b_text_c