The session focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this session you will learn the details and capabilities of T-SQL: Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Type Related Problems; Programmable Objects; Graphs, Trees and Hierarchies.
Along the session you will learn how to use T-SQL to solve practical problems for common requirements via SQL Server SET based approach. We will try to cover close to 10 different scenario’s and their practical solution via some of the features available inside SQL Server.
[youtube nnS_gQiAYms]
Video producer: www.saltmarch.com