This session will cover a range of SQL coding and approaches to various problems faced by anyone writing complex TSQL every day. We'll look at using some under appreciated features and syntax and also some alternate approaches to solving various problems such as unpivoting data and also working with dates.

Finally we'll examine some misconceptions around TSQL & SQL server and look at how they came about and the best way around them

(no tags)
Presented by David Morrison at SQLBits XII
MP4 Video HD 571 MB