Hi - I'm training up a junior dba to use TSQL - Do you know any good online tutorials or microsoft/ MSDN sites that run through some examples of TSQL. My aim is to get him to an extremely high standard but want to start from a basic standard. Many thanks
Study the syntax basics. Bring along some understanding of procedural programming. Then check out the performance tuning articles here on the site, especially the one on "performance audit" - http://www.sql-server-performance.com/articles/per/performance_audit_p1.aspx - well, that's only the first in a series of 8 or 9 instalments. This is a more than excellent "how-not-to" tutorial on everything - from hardware and OS issues to indexing and TSQL coding, and how it all interacts. Must read!!!